Hi,
I would like to do something like
select attr from table
where
oneof list1 IN list2;
such as
select attr from table where
oneof ('apple', 'orange', 'banana') IN ('mango','coconut','banana');
list1 and list2 are attributes in some table(s).
I have three options:
1) There is actually some SQL that does this?
2) I do it with a procedural language function?
3) SQL cannot do it and I need to use perl to do the iteration over a series
of queries with foreach instead of 'oneof'?
What say you?
Thanks, John
