>lcQS = "v_QuickSearch" >SELECT v_QuickSearch.*,; > IIF (EMPTY(v_QuickSearch.cResolution_Codes_Fk) OR ISNULL (v_QuickSearch.cResolution_Codes_Fk),; > v_QuickSearch.cStatus_Codes_Fk,; > v_QuickSearch.cResolution_Codes_Fk) AS cVisCodes_Fk,; > Employee_queue_schedules.cemployee_queue_schedules_pk,; > USERS.cUserID; > FROM (m.lcQS) AS v_QuickSearch; && or macro or [varstring] or TEXT TO > INNER JOIN mmVisCollect!Trans_employees_queues; > ON v_QuickSearch.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 >>