>STRTRAN(tcFilter, "Trans_employees_queues.", "teq.") >>
>>text TO lcSQLStr NOSHOW TEXTMERGE PRETEXT 7 >> SELECT Trans.cTrans_pk, Usgrlink.cUsGrlink_pk, ; >> Users.cUserID, Trans.yCurrent_balance_amount ; >> FROM TRANS INNER JOIN Trans_employees_queues ; >> ON Trans.cTrans_pk = Trans_employees_queues.cTrans_fk ; >> INNER JOIN UsGrLink ON Usgrlink.cUsgrlink_pk IN ; >> (Trans_employees_queues.cCommission_owner_usgrlink_fk, ; >> Trans_employees_queues.cUsgrlink_fk, ; >> Trans_employees_queues.cSupervisor_review_usgrlink_fk) ; >> INNER JOIN USERS ON Users.iID = Usgrlink.iUserID ; >> INNER JOIN Employee_queue_schedules ; >> ON Trans_employees_queues.cTrans_employees_queues_pk = ; >> Employee_queue_schedules.cTrans_employees_queues_fk ; >> WHERE <<m.lcFilter>> >>ENDTEXT >>>>