What is the Opposite of an LEFT Join?

[Glenn1203]

No, I don't mean a RIGHT Join! Instead of all records from the Left table
and only records from the Right table that match the Left Table, I want all
records from the Left table, and only records from the Right table that don't
match the Left table. Is there a way to do this?

Thanks, Glenn

 

[[MVP] S.Clark]

FYI:
Left = Parent
Right = Child

So, it doesn't matter which 'side' the table is on in the Query Design
window. It has to do with the logical relationship of the two tables. (i.e.
One to Many relationship)

Try using the Unmatched Query Wizard to solve, then customize from there.

 

[Jerry Whittle]

Dang! You took away a perfectly good opportunity for me to make a wise-acre
remark. ;-)

Look into a UNION query.

 

[Glenn1203]

Jerry; Doesn't UNION give me all records from both tables, dupes and all?
I'm trying another way to solve the problem you responded to earlier. I need
to return all records from table1, and only records from table2 where the
CircuitID field from table1 and table2 do not match. So at the end I'll have
only one record for each CircuitID.

 

[Jerry Whittle]

A UNION query will give you only distinct records returned. A UNION ALL
allows all returns from both tables. However UNION might not do you any good
because it would allow dupe CircuitID's if any other part of the return was
different.

 

[John Spencer]

Frustrated outer join?

SELECT A.*
FROM A LEFT JOIN B
ON A.PK = B.FK
WHERE B.FK is null

That select all records in A where there is no matching record in B.

If you are doing this in the query grid and can't figure it out then post
back for a description on how to set it up. Or better, post the SQL of your
left join.