+ 9

How does one get to know which table is on the left and which is on the right??

22nd Dec 2017, 1:58 AM
Katleho Nthejane
Katleho Nthejane - avatar
5 Réponses
+ 5
left table is the one mentioned before the join, right one after the join: table1 join table2 left join right
22nd Dec 2017, 11:17 AM
Jeremy
Jeremy - avatar
+ 3
search on google images, it provides great visual of the different joins
22nd Dec 2017, 2:22 AM
manny
+ 2
Doesn't matter. You can switch the order. You just have turn left joins into right joins. Most people limit themselves to left / inner joins only, so order is clear. For an inner join use the more "relevant" table first.
22nd Dec 2017, 2:55 AM
1of3
1of3 - avatar
+ 2
table 1 left join table 2, take all the data from table 1 and matched rows on table 2. the order you write query mattets
3rd Feb 2018, 9:27 PM
Jiaxiang Tang
Jiaxiang Tang - avatar
0
:-)
28th Mar 2018, 4:48 PM
NDLELA MOTABA