George,
Wednesday, January 30, 2002, 7:08:53 PM, you wrote:
GME Hello.
GME If anyone has a quick moment, I would appreciate some suggestions with
GME regards to the following select statement:
GME SELECT widget_src FROM widgets WHERE items.foo='abc123' and
GME item_details.item_type='I' and
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:
You must also define the tables you want to 'look' at in the 'FROM' clause
On Wednesday 30 January 2002 12:08, 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
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