RE: [sqr-users] Subselect

["Harris, Sam" <SVH@CDRH.FDA.GOV>]

Does anyone know how one might be removed from this list?
I have tried to unsubscribe, but I continue to get these messages.

Sam

-----Original Message-----
From: George Jansen [mailto:GJANSEN@aflcio.org] 
Sent: Thursday, July 08, 2004 8:22 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Subselect


You could turn your scalar subquery into an in-line view and avoid the
problem. The following uses standard Oracle data-dictionary views to query
from and runs nicely.

Begin-Program
 
Begin-Select
T.table_name &tn
B.id         &id
        let $id = to_char(&id)
        let $line = &tn || ' ' || $id
        show $line
>From user_tables t,
        (SELECT Sum(column_id) AS id
         FROM user_tab_columns) b
End-Select





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users