List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:January 30 2002 5:56pm
Subject:Re: select woes
View as plain text  
But you are only selecting FROM 'widgets'.

I think you need to buy an introductory book on SQL.

I would also suggest 'MySQL' by Paul DuBois ( published by  New Riders ).

George M. Ellenburg wrote:

>If anyone has a quick moment, I would appreciate some suggestions with
>regards to the following select statement:
>SELECT widget_src FROM widgets WHERE'abc123' and
>item_details.item_type='I' and items.item_detail_id=foo.item_detail_id;
>Upon execution, I'm getting "ERROR 1109: Unknown table 'items' in where
>clause".  However, "widgets", "items" and "item_details" all exist, in
>the same database.

select woesGeorge M. Ellenburg30 Jan
  • Re: select woesJohn Cichy30 Jan
  • Re: select woesGerald Clark30 Jan