JOIN AND UNION

PHOTO EMBED

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