make unique query subject

[nayitian]

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.

[nayitian]

It's resolved.

[MFGF]

What was the resolution? Did you have some items defined with a usage of Unknown, by any chance?

MF.