Missing Operator Syntax Error

[goterps1]

I'm getting a missing operator syntax error when executing the following query. Do I need additional parenthesis or operators when using more then one left join?


SELECT DBO_MASTER.FUND, DBO_MASTER.ACCOUNT, DBO_MASTER.SSN, DBO_MASTER.FIDUCIARY, DBO_MASTER.REGLINE1, DBO_MASTER.REGLINE2, DBO_MASTER.DEALER, DBO_MASTER.SOCIALCODE, DBO_MASTER.DEALERCNTL, DBO_MASTER.CHECKWRITE, DBO_MASTER.MULTICWR, DBO_MASTER.STOPPURCH, DBO_MASTER.STOPXFER, DBO_MASTER.OPENCLOSE, DBO_ACCTXREF.FINS_ID, DBO_ACCTXREF.AGENT_FOR_FIRM_NBR, DBO_ACCTXREF.FIRM_ACCOUNT_NBR, DBO_PURCHASE.ADJUSTMENT_INTERVL, DBO_REDEMPT.AGRMNT_START_DATE INTO [FUND 91]
FROM (DBO_MASTER LEFT JOIN DBO_ACCTXREF ON (DBO_MASTER.ACCOUNT=DBO_ACCTXREF.ACCOUNT) AND (DBO_MASTER.FUND=DBO_ACCTXREF.FUND))
left join DBO_PURCHASE on (DBO_MASTER.FUND=DBO_PURCHASE.FUND) AND (DBO_MASTER.ACCOUNT=DBO_PURCHASE.ACCOUNT)
left join DBO_REDEMPT on (DBO_MASTER.FUND=DBO_REDEMPT.FUND) AND (DBO_MASTER.ACCOUNT=DBO_REDEMPT.ACCOUNT)
WHERE (((DBO_MASTER.FUND)=91) AND ((DBO_MASTER.OPENCLOSE)="O"));

 

[lameid]

Looks to me like you are missing a right parenthesis in your where clause.

Also, worth a mention is that this question would be better suited for the Queries forum.