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 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. > > In looking at the MySQL manual, section 6.4.1 (SELECT syntaxt), the > following is written: "You can refer to a column as col_name, > tbl_name.col_name, or db_name.tbl_name.col_name." which I'm doing, and > all tables referenced are in the same database. Here's the following > output from mysql status: > > mysql> status > -------------- > mysql Ver 11.15 Distrib 3.23.44, for -freebsd4.4 (i386) > > Connection id: 295 > Current database: test_database > Current user: root@localhost > Current pager: stdout > Using outfile: '' > Server version: 3.23.44 > Protocol version: 10 > Connection: Localhost via UNIX socket > Client characterset: latin1 > Server characterset: latin1 > UNIX socket: /tmp/mysql.sock > Uptime: 5 days 20 hours 55 min 10 sec > > Threads: 1 Questions: 13038 Slow queries: 0 Opens: 200 Flush tables: > > 1 Open tables: 7 Queries per second avg: 0.026 > -------------- > > mysql> > > If anyone has any suggestions or pointers to nudge me in the right > direction, I'd be most appreciative. > > --George Ellenburg > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php