I believe this has already been answered
You will have to specify which table you want the customerid to be pulled from. Look in the previous messages for the code or atleast look in the archives. >>> [EMAIL PROTECTED] 08/18/03 11:36AM >>> I get a How do I fix this SQL error please? ODBC Error Code = 37000 (Syntax error or access violation)<P><P> [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'customerid' Both orders and customers have a customerid column My statement: <cfquery name="Getcustomer" datasource="printprices"> SELECT * FROM bookinfo, orders, customers Where bookinfo.bookid = orders.bookid Thanks! Robert O HWW ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
