Hi, > I know what the deal is supposed to be but can't seem > to fix it. > Two tables, VendorID exists in both tables (neither > are primary keys) > > I'm getting a "VendorID in where clause is ambiguous" > Sometimes it actually processes the SQL weird. > I think this is because same column name in both > tables, yet I have other same name in tables with no > effect. I tried alias on VendorJobs.VendorId AS Ven , > etc but it spit it back at me in the where clause with > an unknown. > > Here is the SQL: > > SELECT > `VendorJobs`.`JobID`, > `VendorJobs`.`Contact`,
--8<-- snip > (`VendorJobs`.`TravelReq` = > `staTravelReq`.`TravelReqID`), > `VendorSignUp` > WHERE (vendorjobs.`VendorID` = 13) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]