left join and outer join
-
What is the difference between LEFT JOIN and LEFT OUTER JOIN?? i.e. what is the difference between INNER JOIN and OUTER JOIN?? I was confused with these two joins..
-
What is the difference between LEFT JOIN and LEFT OUTER JOIN?? i.e. what is the difference between INNER JOIN and OUTER JOIN?? I was confused with these two joins..
I got the answer friends. Both are same. Then why the concept of outer join came??
-
I got the answer friends. Both are same. Then why the concept of outer join came??
When writing a query, I like to be explicit about what is intended to do. If I want only records with a match, they I say 'INNER JOIN'. If I want partial matches, I say 'LEFT OUTER JOIN' or 'RIGHT OUTER JOIN' based on how I feel like writing the query, but it is usually 'RIGHT OUTER JOIN'. Tim
-
What is the difference between LEFT JOIN and LEFT OUTER JOIN?? i.e. what is the difference between INNER JOIN and OUTER JOIN?? I was confused with these two joins..
Check this article Visual Representation of SQL Joins[^]
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
-
When writing a query, I like to be explicit about what is intended to do. If I want only records with a match, they I say 'INNER JOIN'. If I want partial matches, I say 'LEFT OUTER JOIN' or 'RIGHT OUTER JOIN' based on how I feel like writing the query, but it is usually 'RIGHT OUTER JOIN'. Tim
Why cant we use left join instead of left outer join??
-
Why cant we use left join instead of left outer join??
I did not write the design for whatever version of SQL is in use. My personal preference it to be explicit in what I am doing. If the version supports 'LEFT JOIN' and 'LEFT OUTER JOIN' and treats them the same, then use either one. Some SQL instances use different syntax; I just like the use to be obvious to the reader.
-
Why cant we use left join instead of left outer join??
Left JoinandLeft Outer Joinis the same thing. It's just a matter of verbosity in the syntaxPoliticians are always realistically manoeuvering for the next election. They are obsolete as fundamental problem-solvers. Buckminster Fuller
-
I did not write the design for whatever version of SQL is in use. My personal preference it to be explicit in what I am doing. If the version supports 'LEFT JOIN' and 'LEFT OUTER JOIN' and treats them the same, then use either one. Some SQL instances use different syntax; I just like the use to be obvious to the reader.
ok dude.
-
Left JoinandLeft Outer Joinis the same thing. It's just a matter of verbosity in the syntaxPoliticians are always realistically manoeuvering for the next election. They are obsolete as fundamental problem-solvers. Buckminster Fuller
ok . thanks for your reply.