where clause with subquery not returning.

From: <screwbai_at_my-deja.com>
Date: Tue, 28 Sep 1999 10:36:35 GMT
Message-ID: <7sq5ni$to7$1@nnrp1.deja.com>

1. shows me the table_name from ALL_TAB_COLUMNS
2. shows me the table_uploadfile from qupload. both return the same table_name.
3. 1+2: I use 2 as a subquery to 1 then NO DICE.

This should be simple andy ideas of what I am doing wrong? Also the subquery only returns one line (the qupload table only has one row in it).

1)
select distinct table_name from ALL_TAB_COLUMNS where table_name='QPRICE';
TABLE_NAME

---

QPRICE
1 row selected.

2)
select distinct table_uploadfile from qupload; TABLE_UPLOADFILE

---

QPRICE 3)
select * from ALL_TAB_COLUMNS where table_name = ( select distinct table_uploadfile from qupload);

OWNER                          TABLE_NAME


------------------------------ ------------------------------

0 rows selected.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 28 1999 - 05:36:35 CDT