0

when you are merging two tables, how to decide which kinds of JOIN you should use?

Im confused about RIGHT JOIN and LEFT JOIN

22nd Oct 2017, 7:25 PM
Kevin ZHU
Kevin ZHU - avatar
1 Antwort
0
Depends on requirements. If you require all rows from left table and only the matching rows from right table,you will use left join. Similar approach for right join and full outer join.
29th Oct 2017, 9:13 AM
Mohan D
Mohan D - avatar