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 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.