PLSQL syntax question
From: Jon Schlatter <*jon-schlatter_at_stamats.com>
Date: Mon, 27 Aug 2001 11:00:16 -0500
Message-ID: <tokr58jmtcfu84_at_corp.supernews.com>
[Quoted] [Quoted] I need to perform a select statement that does a group by and the supresses [Quoted] duplicate entries. I am writing a job status report and have the following select statemenet written.
WHERE ( PA_JOB.STATUS IN ('A','I') )
ORDER BY PA_JOB.CUSTOMER_REF ASC, PA_JOB.JOB_MANAGER_REF ASC, PA_JOB.PROJECT_NO ASC, PA_JOB.JOB_NO ASC All the data shows up properly, but now I need to supress duplicate entries [Quoted] on the PA_JOB.CUSTOMER_REF field for readability. Can anyone help me?
Date: Mon, 27 Aug 2001 11:00:16 -0500
Message-ID: <tokr58jmtcfu84_at_corp.supernews.com>
[Quoted] [Quoted] I need to perform a select statement that does a group by and the supresses [Quoted] duplicate entries. I am writing a job status report and have the following select statemenet written.
SELECT PA_JOB.PROJECT_NO, PA_JOB.JOB_NO, PA_JOB.DES1,
PA_JOB.JOB_MANAGER_REF, PA_JOB.EST_COMPLETION_DATE, PA_JOB.DEADLINE_DATE, [Quoted] PA_JOB.CUSTOMER_REF, PA_JOB.UD_NOTE FROM K.PA_JOB PA_JOB
WHERE ( PA_JOB.STATUS IN ('A','I') )
ORDER BY PA_JOB.CUSTOMER_REF ASC, PA_JOB.JOB_MANAGER_REF ASC, PA_JOB.PROJECT_NO ASC, PA_JOB.JOB_NO ASC All the data shows up properly, but now I need to supress duplicate entries [Quoted] on the PA_JOB.CUSTOMER_REF field for readability. Can anyone help me?
TIA
Jon
Received on Mon Aug 27 2001 - 18:00:16 CEST