QueryDef problem

Question

Hi!

I'd like to code a "self join query" with IQueryDef. 
I'm using 9.3 sp2.

The SQL query is somethig like this:

SELECT ID
FROM MY_TABLE a, MY_TABLE b
WHERE a.id = b.id
AND a.date_1 = b.date_2

I have problems to do it since I cannot use alias in QueryDef. 
Any ideas? Thank you in advance!

pabloberlanga_jimenez · Answer

Ok. I move the question to the correct place.

Thank you again.

VinceAngelo · Answer

The ArcObjects forum is a better place to discuss this, but I doubt you're using the
correct object to accomplish a self-join.

- V

pabloberlanga_jimenez · Answer

It is 9.3.1 you're right.

But I think the query has logic:

SELECT id
FROM table a, table b
WHERE a.id = b.id
AND a.start_date = b.end_date

id       |      start_date      |   end_date   | more data....
181    |      01/02/2012    |   30/02/2012  | ...
181    |      01/01/2012    |   01/02/2012  |  ...

I would get this 181.

Thanks for you attention!!! 🙂

If I launch the query in SQL Server I get the waited results But If I construct the QueryDef and I evaluate it, it returns Nothing.