sql server - Assistance with a 4 table Join operation -

in attempt of being clear posible, have 4 tables in database follows

1. join_contrato_medidor

   • id_union (identity)
   • id_contrato
   • id_medidor
   • omitido (filger ?)

2. promedios

   • id_contrato
   • id_medidor
   • id_marchamo
   • {info want}

3. medidores

   • id_medidor
   • id_dispensario (filter ?)

4. marchamo

   • id_marchamo

my current sql statement...

select {promedios.li_1, promedios.lf_1, promedios.total_1, promedios.qva_1, ...}

from (((

join_contrato_medidor left outer join promedios on join_contrato_medidor.id_contrato = promedios.id_contrato)

left outer join medidores on join_contrato_medidor.id_medidor = medidores.id_medidor)

left outer join marchamo on promedios.id_marchamo = marchamo.id_marchamo)

where (join_contrato_medidor.id_contrato = ?) , (medidores.id_dispensario = ?) , (join_contrato_medidor.omitido <> true)

the output im obtaining:

information columns | omitido | id_union

1. info | false | 806

2. info | false | 806

3. info | false | 806

4. info | false | 806

*i wanted include image cannot until have more reputation :( *

i have 4 tables joining right now. getting columns desired output in query, thing records in --join_contrato_medidor.omitido <> true-- instead of getting records match id_contrato , id_dispensario conditions.

as sample, outputing id_union, identity field join_contrato_medidor. marking records single id_union, happens 1 record out of 4 has omitido <> true. also, latest 3 records have omitido field set true in database nevertheless showing false in query result.

if question unclear, please post me clarification.

thanks in advance

after working on other things until had face issue again, checking it. comment led me try , see if switching order of tables job, , did! thank much.

i started asking hte promedios table first , nperform rest of query. gave me access exact information wanted. moreover, following queries created them following order , lead better shorter queries.