Left Outer Join 1

[jeffsturgeon2002]

What is the difference between a Left Join and a Left Outer Join? Trying to understand what the outer does to the Left ... sorry for the novice question.



Jeff

SELECT * FROM users WHERE clue > 0

 

[SQLDenis]

>>What is the difference between a Left Join and a Left Outer Join

nothing Outer is optional

the 2 statements below are also the same but the as for the alias is optional

select col1 as a
select col1 a




Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[jeffsturgeon2002]

Thanks!!

Jeff

SELECT * FROM users WHERE clue > 0