Re: Another Join Problem

Thanks V On Fri, Oct 2, 2009 at 11:08 AM, Mark Goodge wrote: > Victor Subervi wrote: > >> Hi; >> I get the following error: >> >> *SQL query:* >> >> SELECT ID, Item >> FROM products >> JOIN categories ON categories.ID = products.Category >> LIMIT 0 , 30; >> >> *MySQL said:* >> #1052 - Column '

Re: Another Join Problem

Victor Subervi wrote: Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID fiel

Re: Another Join Problem

Victor Subervi wrote: Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID fiel

Re: Another Join Problem

Qualify the column names. EG SELECT categories.ID, products.Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; Regards John Daisley > Hi; > I get the following error: > > *SQL query:* > > SELECT ID, Item > FROM products > JOIN categories ON categories.ID =

Re: Another Join Problem

On Fri, Oct 2, 2009 at 10:53 AM, Victor Subervi wrote: > Hi; > I get the following error: > > *SQL query:* > > SELECT ID, Item > FROM products > JOIN categories ON categories.ID = products.Category > LIMIT 0 , 30; > > *MySQL said:* > #1052 - Column 'ID' in field list is ambiguous > > Please note

Another Join Problem

Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID field and so does "categorie