Types
of joins in Access QBE (GUI)
Click on each image for more
info :
“Inner” Join
“Left Outer” Join uses all
rows from “primary” table :
“Right Outer” Join uses all
rows from related “foreign” table :
There is such a thing as a
“Full Outer” Join
which retrieves all rows from both the “related” and the “foreign” tables.
That’s all about them for now, though; we won’t use them
although I’ll leave it up to you to
figure why they would be useful.
“Self-Join” connects some
rows in one table to other rows in the same table :
