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
