>lcFrom = 'v_QuickSearch' >SELECT myView.*, ; > IIF(EMPTY(myView.cResolution_Codes_Fk) OR ; > ISNULL(myView.cResolution_Codes_Fk), ; > myView.cStatus_Codes_Fk, ; > myView.cResolution_Codes_Fk) AS cVisCodes_Fk, ; > Employee_queue_schedules.cemployee_queue_schedules_pk, USERS.cUserID ; > FROM (lcFrom) as myView ; > INNER JOIN mmVisCollect!Trans_employees_queues ; > ON myView.cTrans_PK = Trans_employees_queues.ctrans_fk ; > INNER JOIN mmVisCollect!usgrlink ; > ON Trans_employees_queues.ccommission_owner_usgrlink_fk = usgrlink.cusgrlink_pk ; > INNER JOIN mmVisCollect!Employee_queue_schedules ; > ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_schedules.ctrans_employees_queues_fk ; > INNER JOIN mmVisCollect!USERS ; > ON USERS.iid = usgrlink.iuserid; > WHERE Trans_employees_queues.iactive_flag = 1 ; > AND Employee_queue_schedules.iactive_flag = 1 ; > INTO CURSOR cTempResult >