Re: where clause with subquery not returning.

Thanks to all of you that replied. The problem was that I was comparing CHAR to VARCHAR2. I am a looser!!

Thanks folks.

In article <7sq5ni$to7$1_at_nnrp1.deja.com>,   screwbai_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 12:40:09 CDT