SQL Syntax Error

[hellfire45]

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!

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

 

[Norie]

What happens if you use the actual table names instead of the aliases?

 

[Darren Bartrup]

Is it that there's no space before your FROM clause?
Or the quotes around the alias table name?

I get asked for a parameter value (Ent.sKeyField1) using a table in my database if I use
SELECT Ent.sKeyField1 AS "File#" FROM tbl_SYS_System AS "Ent"

but not if I use
SELECT Ent.sKeyField1 AS "File#" FROM tbl_SYS_System Ent
I do however get the field name in quotes

If I use
SELECT Ent.sKeyField1 AS File# FROM tbl_SYS_System Ent
I get a reserved word on the #

To work as I intend I have to write it as
SELECT Ent.sKeyField1 AS File FROM tbl_SYS_System Ent