Re: Column in field list is ambiguous

Thanks Michael, That was the solution. This was the first time I've seen that error and now it makes plenty of sense. Thanks, Grant Michael Stassen <[EMAIL PROTECTED]> wrote: Grant Giddens wrote: > Hi, > > I'm using mysql 4.1.14 and and getting this error: > > Column 'asin' in field list i

Re: Column in field list is ambiguous

Grant Giddens wrote: > Hi, > > I'm using mysql 4.1.14 and and getting this error: > > Column 'asin' in field list is ambiguous > > This is the query that is giving me the error: > > SELECT pn_pricecompare_searchdata.prod_id, > MATCH (asin,upc,...) AGAINST ('warcraft' IN BOOLEAN MODE) AS