SELECT <<m.lcFieldList>> ; FROM TRANS INNER JOIN Trans_employees_queues ; ON Trans.cTrans_pk = Trans_employees_queues.cTrans_fk ; INNER JOIN UsGrLink ON ; Trans_employees_queues.cCommission_owner_usgrlink_fk = Usgrlink.cUsgrlink_pk ; INNER JOIN USERS ON Users.iID = Usgrlink.iUserID ; <<m.tcAdditionalJoin>> ; INNER JOIN Employee_queue_schedules ; ON Trans_employees_queues.cTrans_employees_queues_pk = ; Employee_queue_schedules.cTrans_employees_queues_fk ; WHERE <<m.lcFilter>> ; <<m.lcGroupBy>>where lcFilter is
lcFilter = m.lcFilter + [Trans.cResolution_Codes_fk is Null ] + ; [ AND Employee_queue_schedules.tScheduled_time <= ] + ; TimeToStr(dtot(m.tdDate+1)-1) + ; [ AND Trans_employees_queues.iActive_Flag = 1 ] + ; [ AND Employee_queue_schedules.iActive_Flag = 1]As you see, there is no restrictions on Users table. My tcAddtionalJoin passes a join to a temp cursor containing cUserID list and indexed on cUserID field. My question is: