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:

>Hello.
>
>If anyone has a quick moment, I would appreciate some suggestions with
>regards to the following select statement:
>
>SELECT widget_src FROM widgets WHERE items.foo='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.
>


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