INNER JOIN: is used when retrieving data from multiple tables and will return only matching data. LEFT OUTER JOIN: is used when retrieving data from multiple tables and will return left table and any matching right table records. RIGHT OUTER JOIN: is used when retrieving data from multiple tables and will return right table and any matching left table records FULL OUTER JOIN: is used when retrieving data from multiple tables and will return both table records, matching and non-matching. INNER JOIN : SELECT select_list From TableA A Inner Join TableB B On A.Key = B.Key LEFT OUTER JOIN : SELECT select_list From TableA A Left Join TableB B On A.Key = B.Key (where b.key is null)//For delete matching data RIGTH OUTER JOIN : SELECT select_list From TableA A Right Join TableB B On A.Key = B.Key FULL JOIN : SELECT select_list From TableA A FULL OUTER Join TableB B On A.Key = B.Key
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