maverick00
MIS
Say there is a 1 to many relationship of table A (1) to table B (Many). A person wants a unique list of document ids from A based on multiple choices in table B.
In SQL this would be a simple Select distinct doc_id from A,B where B.item in ('this','that','whatever').
Now, how do I create this in my universe? How does one do a select distinct?
In SQL this would be a simple Select distinct doc_id from A,B where B.item in ('this','that','whatever').
Now, how do I create this in my universe? How does one do a select distinct?