RE: [sqr-users] Subselect

["PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>]

The link to subscription facilities (including unsubscribing) can be
found at the bottom of every message :-)

http://www.sqrug.org/mailman/listinfo/sqr-users 

>>> SVH@CDRH.FDA.GOV 2004/07/08 12:23:27 >>>
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

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