select woes

2002-01-31 Thread Victoria Reznichenko
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

select woes

2002-01-30 Thread George M. Ellenburg
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:

Re: select woes

2002-01-30 Thread John Cichy
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

Re: select woes

2002-01-30 Thread Gerald Clark
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