Question About Joins - Microsoft Access Expert 1


	Back to Access Expert 1 Comments List

Upload Images Link Email

Question About Joins

Abdulhadi Qasem

3 years ago

hi
small question regarding joining properties, i think when you joined the first relationship (lead source) as left join, it must be technically the second relationship ( shipping ) also set left join. i think we cannot mix the properties for joining relationships.

	Richard Rost 3 years ago
Hi there. To which lesson are you referring, specifically, and at what time index? Help me out here... this course is about 10 years old. :)

	Abdulhadi Qasem OP 3 years ago
hi lesson 03 relational queries 11:25 when you chose the second option for the first relationship

	Richard Rost 3 years ago
I just re-watched it, and the video is correct. You have to set up an outer (left) join between customers and lead sources, AND ALSO customers and shipping methods. That's what I did.

	Abdulhadi Qasem OP 3 years ago
yes i am with you can you set one left join ( for example between customers and lead sources ) and the other one ( customers and shipping methods ) as equal ? or no , we cannot have one left join and the other one equal ?

	Kevin Robertson 3 years ago
You can set on join to outer (Left) and the other to inner (equal) but if you are missing a value, for example ShippingID, then your query will be missing those records with the missing value.

	Richard Rost 3 years ago
They're always EQUAL. They have to match in both tables. The difference with an outer join is that it says "show this record even if there is NO match." Watch Outer Joins.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 1.