Hi,
I currently have a MS Access select query (pretty lengthy) that runs fine in MS Access, however I now need to convert this query to Oracle's equivelant SQL syntax so that I can create a SQL view in Oracle.
Any help is appreciated!!
Here's the MS Access select query:
SELECT TC_PFIZER_T_PROJECT.NUMBER_STRING_UPPER, TC_PFIZER_T_PROJECT.NAME, TC_PFIZER_T_CONTACT.FIRST_NAME, TC_PFIZER_T_CONTACT.NAME, TC_PFIZER_CONT_CAT_78.COPFIZERGUID, TC_PFIZER_T_PROJECT_1.NAME
FROM TC_PFIZER_CONT_CAT_78 INNER JOIN ((TC_PFIZER_PROJ_CAT_7252 INNER JOIN (((TC_PFIZER_J_PROJ_ASSIGNEE INNER JOIN TC_PFIZER_Y_USER AS TC_PFIZER_Y_USER_1 ON TC_PFIZER_J_PROJ_ASSIGNEE.USER_ID = TC_PFIZER_Y_USER_1.PRIMARY_KEY) INNER JOIN TC_PFIZER_T_CONTACT ON TC_PFIZER_Y_USER_1.CONTACT_ID = TC_PFIZER_T_CONTACT.PRIMARY_KEY) INNER JOIN TC_PFIZER_T_PROJECT ON (TC_PFIZER_T_PROJECT.MAIN_ASSIGNEE_ID = TC_PFIZER_J_PROJ_ASSIGNEE.PRIMARY_KEY) AND (TC_PFIZER_J_PROJ_ASSIGNEE.PROJECT_ID = TC_PFIZER_T_PROJECT.PRIMARY_KEY)) ON TC_PFIZER_PROJ_CAT_7252.PROJECT_ID = TC_PFIZER_T_PROJECT.PRIMARY_KEY) INNER JOIN TC_PFIZER_T_PROJECT AS TC_PFIZER_T_PROJECT_1 ON TC_PFIZER_PROJ_CAT_7252.PFCFPRACTICEGROUP = TC_PFIZER_T_PROJECT_1.PRIMARY_KEY) ON TC_PFIZER_CONT_CAT_78.CONTACT_ID = TC_PFIZER_T_CONTACT.PRIMARY_KEY
WHERE (((TC_PFIZER_T_PROJECT_1.NAME)="Corporate Compliance") AND ((TC_PFIZER_T_PROJECT_1.APPLICATION_ID)=2183) AND ((TC_PFIZER_T_PROJECT_1.DEFAULT_CATEGORY_ID)=6794) ) OR (((TC_PFIZER_T_PROJECT_1.NAME)="Employment Law")) OR (((TC_PFIZER_T_PROJECT_1.NAME)="IP - Enforcement"));