This content has been marked as final. Show 2 replies
Afternoon, can anyone help with this error....
I'm trying to join a couple of tables
part of the script is below (this works ok as an SQL query), but I'm getting an error code
SQL##f - SqlState: 37000, ErrorCode: 4104, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "dbo_search_Incident_Custom_Joined.IncidentID" could not be bound.
FROM any ideas Thanks
V_IncidentDB.dbo.search_Incident_Complaints_custom RIGHT JOIN (V_IncidentDB.dbo.search_Incident_IncidentTypes INNER JOIN
search_Incident_IncidentTypes.IncidentID = dbo_search_Incident_Custom_Joined.IncidentID) ON
search_Incident_Complaints_custom.IncidentID = search_Incident_IncidentTypes.IncidentID