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.
