Prefix it with the table name of the one you really want. Probably want to alias it as well.
myTable.customerID as thisCustomerID Timothy Heald Information Systems Specialist Overseas Security Advisory Council U.S. Department of State 571.345.2235 -----Original Message----- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 12:55 PM To: CF-Talk Subject: ambiguous 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