| Subject | Select distinct record from the Master table through a join |
|---|---|
| Author | Junior Ang |
| Post date | 2001-12-03T08:03:40Z |
Hi,
Greetings.
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,
jr
[Non-text portions of this message have been removed]
Greetings.
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,
jr
[Non-text portions of this message have been removed]