Difference between LEFT and RIGHT OUTER Joins in SQL - MySQL Join example 1) LEFT OUTER join includes...

Please Visit: http://ift.tt/1ajReyV

Difference between LEFT and RIGHT OUTER Joins in SQL - MySQL Join example

1) LEFT OUTER join includes unmatched rows from left table while RIGHT

OUTER join includes unmatched rows from right side of table.

2) Result of LEFT OUTER join can be seen as INNER JOIN + unmatched rows

of left able while result of RIGHT OUTER join is equal to INNER JOIN +

unmatched rows from right side table.

3) In ANSI SQL, left outer join is written as LEFT JOIN while right

outer join is written as RIGHT JOIN in select sql statements.

http://ift.tt/1k3nqwR

http://ift.tt/1rgbz5a

Difference between LEFT and RIGHT OUTER Joins in SQL - MySQL Join example

from Public RSS-Feed of Jeffery yuan. Created with the PIXELMECHANICS 'GPlusRSS-Webtool' at http://gplusrss.com http://ift.tt/1qPikbY

via LifeLong Community