>This almost works. However, the complete list has 15 items. My list 'SDE' has 13 items(1-13). But the compiled list does not show item 14, it skips it.
>
>

>
>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?

Move that condition into AND clause, e.g.

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"