> 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:
> (`VendorJobs`.`TravelReq` =
(vendorjobs.`VendorID` = 13)
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL