Re: SQL Question
From: <aqs472_at_my-deja.com>
Date: Fri, 15 Dec 2000 18:13:57 GMT
Message-ID: <91dn0t$9hj$1_at_nnrp1.deja.com>
Date: Fri, 15 Dec 2000 18:13:57 GMT
Message-ID: <91dn0t$9hj$1_at_nnrp1.deja.com>
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 - 19:13:57 CET