topic Re: join error in QlikView https://community.qlik.com/t5/QlikView/join-error/m-p/442182#M1154852 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">dbo_search_Incident_Custom_Joined.IncidentID</SPAN> should probably be <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">search_Incident_Custom_Joined.IncidentID</SPAN></P></BODY></HTML> Thu, 14 Mar 2013 13:36:14 GMT Gysbert_Wassenaar 2013-03-14T13:36:14Z join error https://community.qlik.com/t5/QlikView/join-error/m-p/442180#M1154850 <HTML><HEAD></HEAD><BODY><P>Afternoon, can anyone help with this error....</P><P></P><P>I'm trying to join a couple of tables</P><P></P><P>part of the script is below (this works ok as an SQL query), but I'm getting an error code</P><P></P><P>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.</P><P></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>FROM <BR />V_IncidentDB.dbo.search_Incident_Complaints_custom RIGHT JOIN (V_IncidentDB.dbo.search_Incident_IncidentTypes INNER JOIN <BR />V_IncidentDB.dbo.search_Incident_Custom_Joined ON <BR />search_Incident_IncidentTypes.IncidentID = dbo_search_Incident_Custom_Joined.IncidentID) ON <BR />search_Incident_Complaints_custom.IncidentID = search_Incident_IncidentTypes.IncidentID </P><P></P><P></P><P>any ideas</P><P>Thanks</P><P></P></BODY></HTML> Thu, 14 Mar 2013 13:16:38 GMT https://community.qlik.com/t5/QlikView/join-error/m-p/442180#M1154850 2013-03-14T13:16:38Z Re: join error https://community.qlik.com/t5/QlikView/join-error/m-p/442181#M1154851 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Please use "<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">dbo.search_Incident_Custom_Joined.IncidentID" instead of <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">dbo_search_Incident_Custom_Joined.IncidentID</SPAN>&nbsp; </SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Hope it helps<BR /></SPAN></P></BODY></HTML> Thu, 14 Mar 2013 13:27:51 GMT https://community.qlik.com/t5/QlikView/join-error/m-p/442181#M1154851 MayilVahanan 2013-03-14T13:27:51Z Re: join error https://community.qlik.com/t5/QlikView/join-error/m-p/442182#M1154852 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">dbo_search_Incident_Custom_Joined.IncidentID</SPAN> should probably be <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">search_Incident_Custom_Joined.IncidentID</SPAN></P></BODY></HTML> Thu, 14 Mar 2013 13:36:14 GMT https://community.qlik.com/t5/QlikView/join-error/m-p/442182#M1154852 Gysbert_Wassenaar 2013-03-14T13:36:14Z