Thread: query help
View Single Post
  #13 (permalink)  
Old 08-07-10, 16:01
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by sakitram View Post
here is the query
now we're making progress

before going to stage 2, i wonder if i could ask you to please rewrite this query using JOIN syntax instead of the implicit comma join you have now

also, would you please assign a column alias to the MAX expression
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote