Search code examples
universeunidata

How can I SELECT records using a select list made of foreign keys?

I have a table, DEBTOR, with a structure like this:

DEBTOR

and a second table, DEBTOR.INFO structured like this:

DEBTOR.INFO

I have a select list made of record IDs from the DEBTOR.INFO table. How can I

select * from DEBTOR WHERE 53 IN (name of select list)?

Is this even possible?

I realize this query looks more like SQL than RetrieVe but I wrote it that way for an easier understanding of what I'm trying to accomplish.

Currently, I accomplish this query by writing

SELECT DEBTOR WITH 53 EQ [paste list of DEBTOR.INFO record IDs]

but obviously this is unwieldy for large lists.

Solution

  • It looks to me that you cant do that. Even if you use and i-descriptor, It only works in one direction. TRANS("DEBTOR.INFO",53,0,"X") works from the DEBTOR file but not the other way. So TRANS("DEBTOR",@ID,53,"X") from DEBTOR.INFO will return nothing.

    See this article on U2's site for a possible solution.