query not corresponding data on three field

[diegomarino]

hi, i made this query

SELECT Conto.ID, Conto.Data, Conto.Entrate, Conto.Uscite, Conto.Descrizione, Conto.[Descrizione Completa], Conto.Stato, Conto.Moneymap, Conto.ContoFROM Conto LEFT JOIN MovimentiTotali ON (Conto.Entrate = MovimentiTotali.Entrate) OR (Conto.[Data] = MovimentiTotali.[Data]) OR (Conto.[Uscite] = MovimentiTotali.[Uscite])
WHERE (((MovimentiTotali.Data) Is Null));

i works (so far), i made it cause i want to find records that i have in "conto" table that have not match in "movimentitotali" table.
i cannot use id cause in the "movimentitotali" table i add some records that i add not in "conto".

is it correct?

[CJ_London]

not sure what you are asking - you say it works so what is the problem?

[diegomarino]

the problem is that i tried it but i'm not aware of the logic behind it. the result is fine, but changing the "and" in the join to "or" does really what i want? find no matching data considering three fields?

[orange]

diego,

In the Access query options, review unmatched query.