Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> classic header detail report, don't want duplicate detail records.
two tables, one to many relationship. Second table can have duplicate records.
Want a classic report
master
detail
detail
detail
But don't want duplicate detail records.
Here's the very simple code without addressing duplicates.
SELECT JCPMASTER.KEY1, JCPDETAIL.DATA2
FROM JCPDETAIL, JCPMASTER
WHERE (JCPMASTER.KEY1 = JCPDETAIL.REPEATS)
KEY1 AND REPEATS ARE MY REF KEYS.
Many Thanks.
Received on Thu Sep 15 2005 - 12:46:19 CDT