> >testconnString = "select T.recseq, T.descriptn, case when UA.menuindex IS NULL then '' else 'Active' end as Flag" +; >" from webprddt1.wqmsmnulst T LEFT JOIN webprddt1.wqmsmnuprf UA ON T.recseq = UA.menuindex" +; >" Where userid = 'SDE' Or userid Is Null Order By 1" > >Which table the UserID column belongs to?
select T.recseq, T.descriptn, case when UA.menuindex IS NULL then '' else 'Active' end as Flag" +; >" from webprddt1.wqmsmnulst T LEFT JOIN webprddt1.wqmsmnuprf UA ON T.recseq = UA.menuindex" +; >" AND UA.userid = 'SDE' Order By T.RecSeq"