Outer join in access

what i knew is access support right and left join, but does it support outer join on 2 tables ? meant that each of the table doesn't need to have value or match to other table. does it called outer join ? can it be done in access ?
Explorer060599Asked:
Who is Participating?
 
nico5038Connect With a Mentor Commented:
Already answered it in parts yourself.
Just create a query with a LEFT and one with a RIGHT join, both with a test or the key of the "optional side" is empty.
These only needs to be "concatenated" by a UNION and you have a "full outer join".

Clear ?

Nic;o)
0
All Courses

From novice to tech pro — start learning today.