Help! im sure what is wrong with my query im getting this message below. plesse herm me fugure out whats wrong with my query.

SELECT DISTINCT tblPAandPB.P_B, tblPAandPB.P_A, DO_RS_P.REPLACNG_PT_NR AS P_Z INTO tblPZandPA

FROM tblPAandPB LEFT JOIN

(DO_RES_P ON tblPAandPB.P_A = DO_RES_P.P_NR INNER JOIN

DO_PNG_P_AREA on DO.RES_P.P_NR = DO_PNG_P_AREA.SM_P_NR) ;

Syntax error in JOIN operation. Syntax error in JOIN operation