I wonder if you could do this by exposing the PK/FK attributes so that
you could use them in an expression?
/dev/mrg
On 5/10/06, Mike Kienenberger <[EMAIL PROTECTED]> wrote:
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?
