Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

join error

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
V_IncidentDB.dbo.search_Incident_Complaints_custom RIGHT JOIN (V_IncidentDB.dbo.search_Incident_IncidentTypes INNER JOIN
V_IncidentDB.dbo.search_Incident_Custom_Joined ON
search_Incident_IncidentTypes.IncidentID = dbo_search_Incident_Custom_Joined.IncidentID) ON
search_Incident_Complaints_custom.IncidentID = search_Incident_IncidentTypes.IncidentID

any ideas

Thanks

1 Solution

Accepted Solutions

Re: join error

Hi

Please use "dbo.search_Incident_Custom_Joined.IncidentID" instead of dbo_search_Incident_Custom_Joined.IncidentID 

Hope it helps

2 Replies

Re: join error

Hi

Please use "dbo.search_Incident_Custom_Joined.IncidentID" instead of dbo_search_Incident_Custom_Joined.IncidentID 

Hope it helps

MVP & Luminary
MVP & Luminary

Re: join error

dbo_search_Incident_Custom_Joined.IncidentID should probably be search_Incident_Custom_Joined.IncidentID


talk is cheap, supply exceeds demand