SQL error for invalid name

[Huddle]

I am getting the below error on my query. I can't see the error in the SQL. Please let me know if you can see why I am getting this error. When I run the query it runs fine.



SELECT Tbl_WO_Log.WO_Bldg_Number, LookupQ_Building_Number.[FPS Building Name], LookupQ_Building_Number.[FPS Building Address], LookupQ_Building_Number.City, LookupQ_Building_Number.State, LookupQ_Building_Number.[Inspector Name], Tbl_WO_Log.WO_Number, Tbl_WO_Log.Alarm_Acct, Tbl_WO_Log.Asset_Number, Tbl_WO_Log.System, Tbl_WO_Log.Problem, Tbl_WO_Log.Leadership_Comments, Tbl_WO_Log.Initial_POC, Tbl_WO_Log.Initial_POC_Ph, Tbl_WO_Log.Log_Date, Tbl_WO_Log.Assigned_To, Tbl_WO_Log.Date_Resolved, Tbl_WO_Log.MIST_ID


FROM Tbl_WO_Log LEFT JOIN LookupQ_Building_Number ON Tbl_WO_Log.WO_Bldg_Number = LookupQ_Building_Number.[Building Number]
WHERE (((Tbl_WO_Log.Log_Date)=Date()) AND ((Tbl_WO_Log.Date_Resolved) Is Null));

[Huddle]

here is the error

[ranman256]

those ARE some long names. Try making each table its own query with small alias names:

query: qsBldgInfo
select * from tbl_Building_information as tBldInfo

query: qsBldNum
select * from LookupQ_Building_Number as tBldNum

then join these smaller queries togther

[Minty]

I think that error is in your linked query LookupQ_Building_Number , as those fields aren't in the query you have posted.

[Huddle]

That worked, Thanks