SQL Apprentice Question
Can anyone tell me if it is bad practice to use both an INNER JOIN and 
an LEFT OUTER JOIN in the same query on SQL Server 2000?
Celko Answers
Not a problem, but remember that they are executed in left to right 
order, so you may want to use parens and/or make derived tables out of 
some of the results.  Look up the scoping rules for the FROM clause.
Wednesday, May 17, 2006
Subscribe to:
Post Comments (Atom)

 
 
No comments:
Post a Comment