select distinct * from table
<jason_at_cyberpine.com> wrote in message
news:1126806379.729065.221470_at_g44g2000cwa.googlegroups.com...
>
> 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 Fri Sep 16 2005 - 03:57:21 CDT
