Re: sub-select in SQL

[Dennis Lovelady <iseries@xxxxxxxxxxxx>]

These are excellent opportunities to learn how to exploit CTE!  The
worry and the confusion about how the optimizer might process are
mimimized!

declare BL1025INPCursor cursor for
   with t1 as
        (select distinct INSEQ#
           from BL1025INP b
           where
             b.inerrFlg = 'Y'
            )
select * from BL1025INP a
     exception join t1 on a.inseq# = t.inseq#
;