From dondealy@teleport.com Sun, 24 Jun 2001 20:54:50 -0700
From: "Don Dealy II" <dondealy@teleport.com>
Date: Sun, 24 Jun 2001 20:54:50 -0700
Subject: How to return Multi-row query into a single row?
Message-ID: <F001.00335BF0.20010624204019@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Sample Table
 
DocId     
Integer
DateVal   Date
TextVal   
Varchar2(40)
NumVal    
Number(10,0)
 
 
Sample Data
 
<FONT face="Courier New" 
size=2>DocId    DateVal        TextVal        NumVal
<FONT face="Courier New" 
size=2>12       01/15/2000     

<FONT face="Courier New" 
size=2>12                      Sally 
Smith    
<FONT face="Courier New" 
size=2>5                       Bob 
Brown
<FONT face="Courier New" 
size=2>5                                      48702               
5        
07/22/2001
<FONT face="Courier New" 
size=2>4                                      
152
 
 
 
Desired result after SELECT...
 

<FONT face="Courier New" 
size=2>DocId    DateVal        TextVal        NumVal
12       01/15/2000     
Sally Smith
5        
07/22/2001     Bob Brown      
48702
4                                      152
 
 
How do I write a query to produce the "single row" result? 
 
 
 
Thx - Don
 
e:  <A 
href="mailto:dondealy@teleport.com">dondealy@teleport.com