Date: Fri, 16 Feb 1996 07:04:56 GMT
Reply-To: Robert Bachler <danac@INTELE.NET>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Robert Bachler <danac@INTELE.NET>
Organization: CBC Consulting Group
Subject: Re: An SQL question
Carol Bristow <CEB%NCCIBM1.BITNET@VTBIT.CC.VT.EDU> wrote:
>Since this seems to be the week for SQL questions, I've got one that
>I've looked at on and off for a while now.
>I have a database that has "parent" records with multiple "children",
>with each parent-child relationship being one-to-many. I generally
>have to produce reports with the children in adjacent columns. For
>Is there a way to get around the problem of data being duplicated
>when joining the records using SQL? When I have tried using SQL, I
>get duplicate data, which can play havoc when you have to summarize
>the columns at a later step in the report!
If you are getting exact duplicates, use
SELECT DISTINCT <fields>.....
This works like the PROC SORT NODUPS option.