hellfire45
Active Member
- Joined
- Jun 7, 2014
- Messages
- 462
I'm getting a syntax error on this query below. It says "Syntax error on Join". I'm writing this the way I think it would be written in My SQL server 2014 so maybe its not fitting into Access. Can somebody check for me? Thank you so much!
Code:
SELECT FCL.EntityID as "File#", FCL.GroupNumNum as "Numer of Actions", FCL.ActionType as "Action Type", FCL.StartAction as "Action StartDate", FCL.End, ENT.Party3IDText as "Client ID"FROM dbo_FCLIT as "FCL"
LEFT OUTER JOIN dbo_Entities as "ENT" ON FCL.EntityNum = ENT.EntityNum
Where FCL.ActionType = "Answer Affir Defense" AND Party3IDText ="245204" OR Party3IDText = "327599";