can someone explain left outer join and right outer join better? or just give a better example. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

can someone explain left outer join and right outer join better? or just give a better example.

I understand that they only take the data from either from the right table or left table including the similar column/data. but I didn't really get the example that they used. from what I understand from both examples is that they could be the same answer??

23rd Sep 2016, 1:59 PM
Matt Liang
Matt Liang - avatar
2 Answers
0
in left outer join the table benefits d leftmost column i.e it gives d non-matched values also instead of only matching ones...n thus, vice versa in right outer join
24th Sep 2016, 7:12 AM
Blessy Moses
Blessy Moses - avatar
0
yes that what I understood also they are almost the same but work in different directions
2nd Oct 2016, 9:10 PM
Mohamed Ahmed Mohamed Mahmoud
Mohamed Ahmed Mohamed Mahmoud - avatar