Couldn’t you create two Dict items that translate to NATIONALITY, and then SELECT A WITH B.DICT = “Country” AND NO C.DICT = “Country”? I think that it should work. Let us know...
Sent from my iPhone > On Oct 15, 2018, at 12:01 PM, JOSE L MARTINEZ-AVIAL <[email protected]> wrote: > > Hello guys, > > I have three tables A, B and C. The records in table A contain a field ID.B > and a field ID.C, that indicates the ID of an associated record in tables B > and C. Each record in B and C also contain a field called NATIONALITY, which > is single value for B, and multivalue for C. We want to retrieve all records > in A such that the field nationality in B is not among the values of the > fields nationality in C. So it would be something like this(pseudocode) > > SELECT A WITH EVAL 'TRANS("B",ID.B,NATIONALITY,"X") IN > TRANS("C",ID.C,NATIONALITY,"X") ' EQ 0 > > What will be the best option to do this? > > Thanks > > JL > > -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "jBASE" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
