TEXT TO mSqlCommand noshow pretext 15 TEXTMERGE select prempl.lname, prempl.fname, prempl.emplid, jsusers.user, cast(0 as N(1,0) ) as updtflag, cast('' as M) as fmemo from <<xfjsusers>> join <<xfprempl>> on prempl.k_prempl = jsusers.k_prempl where jsusers.dbname == '<<mdbname>>' UNION select jsusers.lname, jsusers.fname, jsusers.emplid, jsusers.user, cast(0 as N(1,0) ) as updtflag, cast('' as M) as fmemo from <<xfjsusers>> where jsusers.dbname == '<<mdbname>>' and jsusers.k_prempl = 0 into cursor c_jsusers readwrite ENDTEXT &mSqlCommand