Hi
I have a query subject based on two tables properly joined. When I select all the items into the query subject, somehow I can have duplicating rows. How can I make this query unique in FM instead of write freehand sql and expilictly add Distinct in the SQL?
Thank you in advance.
It's resolved.
What was the resolution? Did you have some items defined with a usage of Unknown, by any chance?
MF.