From: Yedidyah Bar-David (didi_at_nonexisting.hamakor.org.il)
Date: Thu 10 Jun 2004 - 14:07:50 IDT
No it's not.
What you can do is called a subquery. That is, do a 'select' on the
output of another select, interpreted as data, not as a table name.
Look carefully at the mentioned URL.
-- Didi > On Wednesday 09 June 2004 21:40, Shlomi Fish wrote: > > On Wednesday 09 June 2004 16:50, Amir Hardon wrote: > > > > For once in an SQL statement, you can't select (AFAIR) a table based on the > > value of a select statement. This: > > > > SELECT * > > FROM (SELECT table FROM categories WHERE cat_id = 5) > > WHERE item_id = 103 > > Just for the protocol: this is possible with mssql and oracle: > > http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/2_005_29.htm > > > > > won't work. (at least I think it won't.) > > ================================================================= To unsubscribe, send mail to linux-il-request_at_linux.org.il with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Thu 10 Jun 2004 - 14:18:38 IDT