View Single Post
  #8 (permalink)  
Old December 22nd, 2010, 05:12 PM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Once you give an alias to a table (e.g, "Orders AS O") you can no longer use the full table name to refer to fields.

So if the code does "Orders AS O" then you need to use "O.VendorID"

For the "'Every derived table must have its own alias": Show exactly the query you are now using.
Reply With Quote
The Following User Says Thank You to Old Pedant For This Useful Post:
03jh01 (December 22nd, 2010)