Differance between Left join & Left outer join?

[RITIK]

can any one tell me the differance between Left join & Left outer join?
Thanxs in Advance

[DanielaTm]

It is no difference. Is the same thing

[RITIK]

It is no difference. Is the same thing

R u sure becuse this question is aked in tech interview??

[f_eriksen]

can any one tell me the differance between Left join & Left outer join?
Thanxs in Advance


A LEFT JOIN is actually an implicit LEFT INNER JOIN.

With a Left Join/Left Inner join, only rows that match the join critera will be returned from Both sides.

A LEFT OUTER JOIN returns all rows from the Left side ("parent"), regardless of matches.

example:

Select a.id, b.name
from tablea a left join tableb b on a.id = b.id

-- returns all rows from a that has matching rows in b
-- displays ids from a, names from b

Select a.id, b.name
from tablea a left inner join tableb b on a.id = b.id

-- returns all rows from a that has matching rows in b
-- same as above

Select a.id, b.name
from tablea a left inner join tableb b on a.id = b.id

-- returns all rows from a and any matching rows from b
-- displays all ids from a, names from b where a match exists, null where not

hope that was clear :-)