Heres on that has me stumped...(SQL 2000) Select blah from table1, table2, table3 RIGHT OUTER JOIN table4 on table2.project_id = table4.project_id
Blows up saying table2 is bad column or alias. If I drop the table2 from the project_id it works, but of course badly. Table2 is in the from clause since there are 10 fields being pulled in the select portion of the query specific to that table. Can anyone tell me why I cannot use the table qualifier on the project_id field? Its rather important for making the correct join, eh? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
