In access i have a table A and a table B.
A.asid is the primary key and B.asid is the foreign key.
I need the following set of results
all records of A that do not appear in B OR appear in B and have B.smth = 1
moreover i need the following to stand true
A.check1 = 1 and
A.check2 = 1 and
A.check3 is not null
Can you help me with the query???