topic IQueryDef problem. in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/iquerydef-problem/m-p/300269#M7802 <HTML><HEAD></HEAD><BODY><SPAN>Hi. My enviroment is Arcgis 9.3.1 SP2 and SDE. </SPAN><BR /><BR /><SPAN>I have a problem constructing a QueryDef. I need a self join but it is a problem since a cannot use aliases in a QueryDef.</SPAN><BR /><BR /><SPAN>My SQL query is something like this:</SPAN><BR /><BR /><SPAN>SELECT id</SPAN><BR /><SPAN>FROM table a, table b</SPAN><BR /><SPAN>WHERE a.id = b.id</SPAN><BR /><SPAN>AND a.start_date = b.end_date </SPAN><BR /><BR /><SPAN>id | start_date | end_date | more data....</SPAN><BR /><SPAN>181 | 01/02/2012 | 30/02/2012 | ...</SPAN><BR /><SPAN>181 | 01/01/2012 | 01/02/2012 | ...</SPAN><BR /><BR /><SPAN>I would get this 181. </SPAN><BR /><BR /><SPAN>If I launch it in SQL Server I get the waited result I don't know how to resolve this making a QueryDef. </SPAN><BR /><BR /><SPAN>Thanks in advance!</SPAN></BODY></HTML> Tue, 26 Feb 2013 15:17:04 GMT pabloberlanga_jimenez 2013-02-26T15:17:04Z IQueryDef problem. https://community.esri.com/t5/arcobjects-sdk-questions/iquerydef-problem/m-p/300269#M7802 <HTML><HEAD></HEAD><BODY><SPAN>Hi. My enviroment is Arcgis 9.3.1 SP2 and SDE. </SPAN><BR /><BR /><SPAN>I have a problem constructing a QueryDef. I need a self join but it is a problem since a cannot use aliases in a QueryDef.</SPAN><BR /><BR /><SPAN>My SQL query is something like this:</SPAN><BR /><BR /><SPAN>SELECT id</SPAN><BR /><SPAN>FROM table a, table b</SPAN><BR /><SPAN>WHERE a.id = b.id</SPAN><BR /><SPAN>AND a.start_date = b.end_date </SPAN><BR /><BR /><SPAN>id | start_date | end_date | more data....</SPAN><BR /><SPAN>181 | 01/02/2012 | 30/02/2012 | ...</SPAN><BR /><SPAN>181 | 01/01/2012 | 01/02/2012 | ...</SPAN><BR /><BR /><SPAN>I would get this 181. </SPAN><BR /><BR /><SPAN>If I launch it in SQL Server I get the waited result I don't know how to resolve this making a QueryDef. </SPAN><BR /><BR /><SPAN>Thanks in advance!</SPAN></BODY></HTML> Tue, 26 Feb 2013 15:17:04 GMT https://community.esri.com/t5/arcobjects-sdk-questions/iquerydef-problem/m-p/300269#M7802 pabloberlanga_jimenez 2013-02-26T15:17:04Z