QueryDef problem

[pabloberlanga_jimenez]

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!

[VinceAngelo]

You can accomplish this with Query Layers (at 10.x), but the query itself doesn't really make sense --
it's logically equivalent to "WHERE date_1 = date_2".

- V

BTW: The last 9.3 service pack was SP1 (followed by 9.3.1, which had two SPs).

[pabloberlanga_jimenez]

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!!! 🙂

[pabloberlanga_jimenez]

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.

[VinceAngelo]

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]

Ok. I move the question to the correct place.

Thank you again.