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>


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

Original text of this message