Question:
Hello,
I have an InfoSet with a join between two tables, the result I get is correct, but I would like to delete from the result the duplicate records.
Is there a way to put a SELECT DISTINCT at the selection of the InfoSet, if so, what do I have to do?
Many thanks,
Luz
Answer:
Try an inner join?