Ideal question for Google. You get hundreds of hits in less then a second. Take one and it saves me to type over a complete page.
Inner Join: Evaluate the condition in the "ON" clause for all rows in the cross join result. If true return the joined row. Otherwise discard it.
Left Outer Join: Same as inner join then for any rows in the left table that did not match anything output these with NULL values for the right table columns.
Right Outer Join: Same as inner join then for any rows in the right table that did not match anything output these with NULL values for the left table columns.
Full Outer Join: Same as inner join then preserve left non matched rows as in the left outer join and write non matching rows as per right outer join.
Inner Join
Full Outer Join
156 views
Usually answered in minutes!
×