Typist's cramp ? Can you say visual query builder.
;)
Stuart
--- SGreen@stripped 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 <stuart4m@stripped> 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/mysql?unsub=1
> >
>
