cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <mkien...@gmail.com>
Subject non-SQL query to find distinct relationships in an entity's table?
Date Wed, 10 May 2006 18:59:02 GMT
I'm building a search panel, and I want to populate one of the search
criteria fields with the distinct list of values in the table being
searched.

Basically, the DataObject results returned from:

select * from OTHER_TABLE
    where OTHER_TABLE_PK in
        (select distinct(OTHER_TABLE_FK) from SEARCHED_TABLE)

Is there a way to do this other than using SQL Template?

Mime
View raw message