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"));

 

[PHV]

...
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'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886