outer join shortcut?
Posted by ~Ray @ 2008-11-13 12:34:58
Welcome to the dBforums forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions articles and access our other FREE features. By joining our free community you will have access to post topics communicate privately with other members (PM) respond to polls upload your own photos and access many other special features. Registration is fast simple and absolutely free so please. ! If you have any problems with the registration process or your account login please contact. If you prefer not to see double-underlined words and corresponding ads place your cursor
)the first is an inner join the 2nd would show all result (left outer join) for table1 and only combine the result from table2 that matched. Of course I could be wrong on this if it is something MS SQL specific. Does it allow for just 'outer join'?
__________________Vi veri veniversum vivus viciBy the power of truth. I a living man have conquered the universe
)the first is an inner join the 2nd would show all result (left outer join) for table1 and only combine the result from table2 that matched. Of course I could be wrong on this if it is something MS SQL specific. Does it allow for just 'outer join'?
*= is indeed a left outer join just as =* is a right outer join. It is a T_SQL extension and was valid up thru S2K. It is no longer available in S2K5. It is not in the ANSI Standard so if you want your code to run in SQL Server later than 2000 do not use it!
"To be sure of hitting the target shoot first and call whatever you hit the target." - Ashleigh Brilliant
oops. I am sorry that was something ms sql specific. I should not have answered that. I just didn't see the little * :/sorry about that well. at least I learned something
__________________Vi veri veniversum vivus viciBy the power of truth. I a living man have conquered the universe
*= is indeed a left outer join just as =* is a right outer join. It is a T_SQL extension and was valid up thru S2K. It is no longer available in S2K5. It is not in the ANSI Standard so if you want your code to run in SQL Server later than 2000 do not use it!
Code I inherited. I don't think the db admin knew exactly what he was doing other than taking a shortcut to write less code.
Its not a shortcut. Its an "old cut". It used to be the standard coding syntax so far back in the mists of time that only wise men such as Pat Phelan know the origins.
Copyright ©2001-2008 dBforums com. All Rights Reserved. A division of. Other iNET Interactive Sites: | | | | [ADVERTHERE]Related article:
http://www.dbforums.com/showthread.php?t=1624617&goto=newpost
0 Comments:
No comments have been posted yet!
|
