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