Typist's cramp ? Can you say visual query builder. ;) Stuart --- [EMAIL PROTECTED] wrote:
> You have to say which table's VendorID column you > want to evaluate your > WHERE clause against (just as the error message > says). Try this > > WHERE > (VendorJobs.`VendorID` = 13) > > As a shortcut , and to keep you from getting > "typist's cramp", you only > _need_ to specify the table name for columns that > are NOT unique within > the set of all columns in the tables you have joined > into your query. For > all uniquely named columns, you can drop the table > specifier. > > Don't get me wrong, the way you are specifying your > columns IS the > **correct** method of being specific. I am merely > suggesting a way for you > to save yourself a few keystrokes and maybe a few > typos along the way. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > Stuart Felenstein <[EMAIL PROTECTED]> wrote on > 08/30/2004 04:09:03 PM: > > > 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`, > > `VendorJobs`.`Conmail`, > > `StaIndTypes`.`CareerCategories`, > > `StaUSCities`.`City`, > > `USStates`.`States`, > > `VendorJobs`.`AreaCode`, > > `VendorJobs`.`PayRate1`, > > `VendorJobs`.`PayRate2`, > > `staTravelReq`.`TravelReq`, > > `VendorJobs`.`VendorID` > > FROM > > `VendorJobs` > > INNER JOIN `StaIndTypes` ON > (`VendorJobs`.`Industry` > > = `StaIndTypes`.`CareerIDs`) > > INNER JOIN `StaUSCities` ON > > (`VendorJobs`.`LocationState` = > > `StaUSCities`.`CityID`) > > INNER JOIN `USStates` ON > (`StaUSCities`.`StateID` = > > `USStates`.`StateID`) > > INNER JOIN `staTravelReq` ON > > (`VendorJobs`.`TravelReq` = > > `staTravelReq`.`TravelReqID`), > > `VendorSignUp` > > WHERE > > (`VendorID` = 13) > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
