Re: [sqr-users] Subselect

["George Jansen" <GJANSEN@aflcio.org>]

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