Convert Multiple Joins to SQL Syntax

[CT Witter]

I'm trying to take an access query and convert over to syntax that oracle sql will work with. The problem is that I'm using multiple left joins.

Oracle always returns a "SQL command not properly ended" error when using the below. What is the proper syntax??

FROM (((DB.PROF_CLAIM_HEADER LEFT JOIN DB.MEMBER_MASTER ON DB.PROF_CLAIM_HEADER.SEQ_MEMB_ID = DB.MEMBER_MASTER.SEQ_MEMB_ID) LEFT JOIN DB.VENDOR_MASTER ON DB.PROF_CLAIM_HEADER.SEQ_VEND_ID = DB.VENDOR_MASTER.SEQ_VEND_ID) LEFT JOIN DB.PROV_MASTER ON DB.PROF_CLAIM_HEADER.SEQ_PROV_ID = DB.PROV_MASTER.SEQ_PROV_ID) LEFT JOIN DB.PROV_MASTER AS DB.PROV_MASTER_1 ON DB.PROF_CLAIM_HEADER.SEQ_REF_PROV_ID = DB.PROV_MASTER_1.SEQ_PROV_ID;

THANKS,
CT

 

[Norie]

Are you sure it's to do with the joins?

 

[CT Witter]

If I use the string as is from access it states that the select keyword is missing, however it is the very first word in the SQL statement