Thread: Question on Efficiency of Subquery
View Single Post
  #5 (permalink)  
Old 09-02-10, 18:25
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by ozzii View Post
... there can be duplicates.
there was another guy who has a similar problem as yours -- duplicates

see Aggregate Incorrect with INNER JOIN
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote