You really should only select the individual columns you need. Selecting the customer ID twice is inefficient since it has the same data. But if you must have it, try something like:
SELECT orders.customerID as OrdCustomerID, customers.customerID as CustCustomerID etc, etc. And my guess is that you also want to join on orders.customerID = customers.customerID. HTH... --Jeff _____________________________________________________________ Jeff Langevin Appalachian Mountain Club MIS Department 5 Joy Street, Boston, Massachusetts 02108 Don't judge each day by the harvest you reap, but by the seeds you plant. --Robert Louis Stevenson ____________________Reply Separator____________________ Subject: ambiguous Author: [EMAIL PROTECTED] Date: 8/18/2003 12:45 PM 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 Get the mailserver that powers this list at http://www.coolfusion.com
