Subject Select distinct record from the Master table through a join
Author Junior Ang


If I want to retrieve records from the master table which should not duplicate, when the criteria are to be based on the detail table records, is this the best and only way?

select distinct A.ID from TABLE1 A inner join TABLE2 B on A.ID = B.ID where B.QTY > 100

where TABLE1 is the master table and TABLE2 is the detail table.

Thanks for any advice in advance.

Best wishes,

[Non-text portions of this message have been removed]