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 [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
