JOIN AND UNION
Fri Apr 22 2022 06:18:53 GMT+0000 (Coordinated Universal Time)
Saved by
@Bambibo9799
INNER JOIN - only gets the value that happened to be in both table
LEFT JOIN- get all the value from the table 1( from TABLE)
RIGHT JOIN - get all the value from the joining table (JOIN TABLE)
full join/ outer join - get all the value from both table
UNION removes duplicates, whereas UNION ALL does not.
content_copyCOPY
Comments