SELECT DISTINCT Employee_queue_activity.cemployee_queue_activity_pk,; Employee_queue_activity.ctrans_employees_queues_fk,; Employee_queue_activity.inumber_of_items_worked_count,; Employee_queue_activity.iminutes_per_account_count,; Employee_queue_activity.istatus_changes_count,; Employee_queue_activity.iresolved_accounts_count,; Employee_queue_activity.irequeued_accounts_count,; Employee_queue_activity.tentered_date,; Employee_queue_activity.centered_user,; Employee_queue_activity.tlast_updated_date,; Employee_queue_activity.clast_updated_user; FROM ; MMVISCOLLECT!TRANS_EMPLOYEES_QUEUES ; INNER JOIN MMVISCOLLECT!EMPLOYEE_QUEUE_ACTIVITY ; ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_activity.ctrans_employees_queues_fk ; INNER JOIN MMVISCOLLECT!QUEUE_NAMES ; ON Queue_names.cqueue_names_pk = Trans_employees_queues.cqueue_names_fk ; INNER JOIN MMVISCOLLECT!EMPLOYEE_QUEUE_PROFILES ; ON Queue_names.cqueue_names_pk = Employee_queue_profiles.cqueue_names_fk; WHERE Queue_names.cqueue_names_pk LIKE ( ?VP_CQUEUE_NAMES_PK ); AND ( Employee_queue_activity.tentered_date BETWEEN DATE() AND DTOT(DATE()+1)-1; AND Trans_employees_queues.ccommission_owner_usgrlink_fk = ( ?VP_CUSGRLINK_FK ) )I'm also using several select statements from database using our funciton RunSQL which Sets database to the correct database.