Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Question
Let's breakdown your statement:
> select C1 from (select table_names from mytables where reference
> = 'first');
The (select .... ) part will give you a table whose only column is named table_names.
Therefore, you can only do a select table_names from (...) on your outside select statement.
This is what's wrong with your SQL statement.
I apologize for being so terse in my previous post...
Cheers,
BB
Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 15 2000 - 12:13:57 CST