Access SQL Syntax Troubles... Double LEFT OUTER JOIN

[hellfire45]

It's telling me "Syntax Error [missing operator] in query expression 'dbo_Entities ON dbo_FCLIT.EntityNum = dbo_Entities.EntityNum
LEFT OUTER JOIN Clientname ON dbo_Entities.Party3IDText = Clientname.ClientID'

Any ideas?

SELECT dbo_FCLIT.EntityID as 'File#', dbo_FCLIT.ActionType as 'Action Type', dbo_Entities.Party3IDText as 'Client ID', Clientname.clientname FROM dbo_FCLIT
LEFT OUTER JOIN dbo_Entities ON dbo_FCLIT.EntityNum = dbo_Entities.EntityNum
LEFT OUTER JOIN Clientname ON dbo_Entities.Party3IDText = Clientname.ClientID;

[June7]

See answer in other thread. https://www.accessforums.net/access/...tax-50786.html

[hellfire45]

I don't see the answer to the above question in that thread. I'm trying to join 3 tables together as seen below

SELECT dbo_FCLIT.EntityID AS ['File#'], dbo_Entities.Firstname AS ['Loan#'], dbo_FC_Milestone.Stage, dbo_FCLIT.GroupNumNum AS ['Numer of Actions'], dbo_FCLIT.ActionType AS ['Action Type'], dbo_FCLIT.StartAction AS ['Action StartDate'], dbo_FCLIT.[End], dbo_Entities.Party3IDText AS ['Client ID']


FROM dbo_FCLIT LEFT JOIN dbo_Entities ON dbo_FCLIT.EntityNum = dbo_Entities.EntityNum


LEFT JOIN dbo_FC_Milestone ON dbo_FCLIT.EntityNum = dbo_FC_Milestone.EntityNum


WHERE (dbo_FCLIT.ActionType = 'Answer Affir Defense') AND ((dbo_Entities.Party3IDText ='245204') OR (dbo_Entities.Party3IDText = '327599'));

[hellfire45]

Nevermind. I got it. It was missing brackets on the joins as seen below. That's so weird why would the syntax be different in Access than in SQL server? It's both SQL. SQL is SQL right?

SELECT dbo_FCLIT.EntityID AS ['File#'], dbo_Entities.Firstname AS ['Loan#'], dbo_FC_Milestone.Stage, dbo_FCLIT.GroupNumNum AS ['Numer of Actions'], dbo_FCLIT.ActionType AS ['Action Type'], dbo_FCLIT.StartAction AS ['Action StartDate'], dbo_FCLIT.[End], dbo_Entities.Party3IDText AS ['Client ID']


FROM ((dbo_FCLIT LEFT JOIN dbo_Entities ON dbo_FCLIT.EntityNum = dbo_Entities.EntityNum)


LEFT JOIN dbo_FC_Milestone ON dbo_FCLIT.EntityNum = dbo_FC_Milestone.EntityNum)


WHERE (dbo_FCLIT.ActionType = 'Answer Affir Defense') AND ((dbo_Entities.Party3IDText ='245204') OR (dbo_Entities.Party3IDText = '327599'));