Re: where clause with subquery not returning.

Hi,

    Your SQL is fine, at least it works on my system with no changes. I suspect that your problem can be solved by adding the UPPER function:

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

BTW, you don't need the distinct if qupload contains one and only one row.

regards
jerry gitomer

screwbai_at_my-deja.com wrote in message
<7sq5ni$to7$1_at_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 - 12:14:58 CDT