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.
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter