| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SQL Query to combine multiple rows into 1 ?
I've got a simple table with 2 columns: ID and Relation
E.X.
ID Relation
--- --------
123 Sam 123 Bobby 123 Dani 234 Mary 234 Cindy 345 Steve 456 Karen 456 Gary 456 Wayne
I'm trying to create a report using only ANSI SQL (no PL*SQL, or SQL*PLUS enhancements) to create the following output:
123 Sam Bobby Dani
234 Mary Cindy
345 Steve
456 Karen Gary Wayne
I'm totally stumped- Can anyone help??
Todd Thompson
Architecture and Technology Team
Harris Publishing
6363 Center Drive, Norfolk VA, 23502
Tel: 757.455.5434 Fax: 757.455.3010
Email: tthompso_at_bcharrispub.com <mailto:tthompso_at_bcharrispub.com>
begin 600 winmail.dat
M>)\^(A(-`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0_at_36%I;"Y.;W1E`#$(`06``P`.````T0<%`!(`
M"0`W`!``!0!$`0$@@`,`#@```-$'!0`2``D`-P`1``4`10$!"8`!`"$````T
M-D,Q.3<U13DR-$)$-3$Q.4)&0C`P03!#.4%",D$X,@`T!P$$@`$`+````%-1
M3"!1=65R>2!T;R!C;VUB:6YE(&UU;'1I<&QE(')O=W,@:6YT;R`Q(#\`)P\!
M#8`$``(````"``(``0.0!@`$%0``,P````,`JX`((`8``````,````````!&
M`````%*%``!^'@``'@#+@`@@!@``````P````````$8`````5(4```$````$
M````."XU``L`TX$((`8``````,````````!&``````:%`````````P#,@`@@
M!@``````P````````$8``````84````````+`*:`""`&``````#`````````
M1@`````#A0````````L`U8`((`8``````,````````!&``````Z%````````
M`P"H@`@@!@``````P````````$8`````$(4````````#`-:`""`&``````#`
M````````1@`````1A0````````,`V(`((`8``````,````````!&`````!B%
M````````'@#G@`@@!@``````P````````$8`````-H4```$````!````````
M`!X`Z(`((`8``````,````````!&`````#>%```!`````0`````````>`.F`
M""`&``````#`````````1@`````XA0```0````$`````````'@"@@`@@!@``
M````P````````$8`````@X4```$````3````,3,S,3(T.#$S+3$X,#4R,#`Q
M```+`%&!"R`&``````#`````````1@``````B`````````L`4X$+(`8`````
M`,````````!&``````6(`````````@$)$`$```#[#@``]PX``(Y4``!,6D9U
M^T^S$`,`"@!R8W!G,3(U_at_C(#0VAT;6PQ`S`_`0,!]PJ``J0#XP(`8VC!"L!S
M970P(`<3`H#_$`,`4`16"%4'LA'5#E$#`=T0US(&``;#$=4S!$80V=D2[V8T
M$&\1>S487Q<6;P*`$>,([PGW.QS/#C`U[QWO'<$1X0Q_at_8P!0"PD!9%PS-A%@
M"Z480&,!,"!9$`(J7`ZR`9!G(J`S`"`\(41/0U19`%!%($A434P@`%!50DQ)
M0R`B0"TO+U<S0R6_at_1"141"2T-"X18%1R.0!R=&D"(`=`):!%3GPB/A'C(U<D
M``JC*`PQ+CDD$"3")_XT*E%%0;Y$)_T.\2D?+0\IY#8.\,`\345402`%H`(P
M,0GP=#TB!>`DPS4N$#4P+C0.0#(N,6`X,#`B("=P!X`]`D<GP$52051/4O4G
M_30OT2\K[R/!+G\CL0,Q<"000D]$62!BYF<(4!QA/2,!(#@2)_"7(V,`(0,P
M=@B0=VL+@-1D-2,48@#0:PG`"&#%.9`@``!S:'`C,CKQ60N`<W0ZT3L1<P.@
M9HT#$&PWHP*1<W8@+[!B-SUP,C$U&^`[V$;_/'$)@#SU&^`_83B6$6`C.3PV
M-#B(```_QREL-#A!)!!&3TY4(`"0>OTR@#(X>0'Q"_$#,$'O,]3_-;4XES^O
M(Y,!P#B'1^@*@(DC&SDV)!!$259$2[](#T#?3,=$;T5_(Y,X*[%P4U!!3C!`
M"V`$$#VX,3,S#B!#4%+0+3'QNPY`,A`Q2_]0ST,Y9@#0'S*`!Q-$3$;13,=)
M)W9092!G;P5`84/1;7\+4%DP`9%9\48/->(#\'1,:"`4\!Q!=6T`@#IQ40\F
M;F([\`*`.)@G]F$!0%AX1%S?7>]>^EF`N3JA4F4+8"="*6PU2Y'^+T.2.'E'
MZ4J\%/`T4%(B?V3_3RQ'[TC^"J))_RFW,/\KL28`2]MEKR-U(B$UWTM__TR/
M39].KT^_;R]1WU+O<@__=M]6'U<O6#MCCV2?;L]FO_^`GX&O8*]>OH-O:B]K
M/VQ/_VU?A[]O?W"/<9]RKW._=,__==^-KW?_>0^2KY5?0T@*HX=\WWWO$6!% M+E_at_N?Q__@"^-/X)/GY^'3Y%OB6^*?_^+CZ)?D9^8CY._E,^:'T//_ZR?1>]& M_ZN?J4^E/Z:/CX__JN^IW[BOJ_^PFKP/L,][[_^;L1<FKS.8;!H@`[(OL%A: M_U_/A:]>ZY6?EJ,*HY;_F`__F1_$7\5ORP_,'\TOSC_/3_]AW:#OH?^Y2&,/ MGJ_5O[//_]GON6^E?[:/IY_8W]#OCJ__M\_*;[GOY+^]K^=?Z&_1+_^6G\E/ MYL^_/\!/$S$*H\&/^\*?Y8(M]%#1/])/T'_TW__U[_;_^`_Y'_HO^S]>W/11 M_P`#UV_8?^$OU(\"#]L_!:__Y2_=+]X_WT__at_7P+OXG_CC__N/^6O$'_I;^C?M%"_O/_!/[\$_\K\1%^T0,_TO_C_\;__K?\A/[4\2OQO?'.\=_R.??R2O);\F MSR??T_\$/P?+4_\R8`"/`9\&KS#?,>\(GPFO_PJ_"\\,WPWO#O\0#S.O$B__ M,F\5[S]?.+\7?QB/&9\:K_\;ORG_*"\>[Q__(0\^/TH__TAO27]/'U`O43]2 M3U-?*Z^#++\S34)O8F)Y+N__+_\R3UR?7:\T/S5/-E\W;_\X?SF/.I\[KU]O
M/<]>+T&/_VL?9']#'T0O13]&3T=?59__4\]*CTN?3*]I_W7_="]U/_]ZWWOO M?/]^#W\?5T]87U\-\$1A;FE:KUN_7@^(3_^)7U__80]B'V,O9#]E3V9?_V=O MBQ]ICXG?;4^6SY`O;M_O;^]P__-><Q`T@&^!?W^O_W9O=W]XCY7/GN^?_Z$/ MIJ]_I[^HSZG?JN^#+X0_BMM-_Z-`6I^'7XFOL^^T_XN?C*__C;^.SX_?D.^1M_Y,/MK^5+_^U?YCOPF^9;YI_FX^<GYVO_YZ_K/^K+Z'OHO^D#\%/S4__RW_, MC](OTS_43]5?UF^NK\.OO[9>0VEN9+'_LP__M5_?K^"_MT^X7[EONG^[C_^\
MG[VOOK_B?\#?X3_$G^XOO\4?QB_'/\A/R5_*<#77S__8W]</S<_.W\_O[3_V M7_=O__A__A__+P`_`4\"7]J/VY_A+>QT979EW<_>W^$O_PM_#(_C'^0OY3_F M3^=?Z&__Z7_JCPY/[*\-#_!O&?\37]_Q__,/]!]R#O8P-@./!)__`L_YC_J?M^Z\8_R(?(R\D/_\IWRKO*_\M#RX?!D\'7PX+\DLF<&5N"8\*GPSO-S__.$\. MWP_O$/\2#Q,?%"\5/_\63SH/&&\XSQPO1;\_'QV__Q[/']\@[R'_,#\N;R4O
M)C__)T]$GU"?3L]/WU5_5H]7G]]8KUF_,>\R_SFM1['?-B__.']BOV//.F\[ M?SR//9]E/_\_OT#/0=]"[T/_10]'OW$__T@_24]*7TMO3']-CUO/7-__4+]1 MSU+?;?]\'WI/>U^`_W^"#X,?A"^%/UU_7H]J3R#P5V%Y;@E_8?]D3XZ?_X^O M9C]G3VA?:6]J?VN/;)__;:^1;V_/D"]SCYT?=`]U'^5V(T%VH&%L=N^?4H>0M_\ENC+^-SY9_AQ^(+Y!OJA__D4^27Y-OE'^5CZ<_EZ^8O_^;[YK?M.^>GYX/ MN)^Q_Z$__Z)/HU^[#Z5_L0^GGZBOJ;__P<_%OZSOK?^O#[`?QR^R/_^S3[1? MM6^V?[>/NC_3+[J__WR??:!^'W\O@#^[[[SYOA]!T,=))VT@=�:;1N9][0 M;]@`-1!A"4`\(&'-7+[QSF,U$'!O&<EP('6]L-\A;VYL)'D@?9!320D_at_44R( M("ANWV!03"KBT2XLXB!]\.+1*N-055.B(#4@:&%N=D!M-2#(=',IWTET:-_0
MX!^!SG)F;VQL;W?A\^AU='#H4#K`'\$OS+__B@_J/\;/[=_0O\B_R<_*W__+ M[^L?S@_/']G/T3_XK]3__]1O_%_6C]>?V*_ZO]K/V]__O8%]P[V_OL\#/^F/ M]/_KK__LOPJ?PW_$C^]?$%_Y3_%/__)?\V_T?PU_]I_WKP)?^<__&R_]CQW/ M'M\#7P1OO9\&WRL;Y`$@,^+`8=[`0F_48F+B8$3DP&D(3PE?_Q%/*3\J3Q,_ M%$\57Q9O%W__&(\9GQJO+`\<SRK/((\WOW\Q'R(?(R\D/WA\)C`.L$WI8,$@ M0]\09&#O*$\JG_]"3T-?+(\MGRZO+[\PSS'?_S+O,_]%'S8?0]\YWU#/.E^_M.V\\?SV/>&T_D'@P4]_`_G:,KT%O0[];'UPO1:]&O_]'STC?2>]*_TP/31]= M[T\__URO4O]IGU-_5(]5GU:O>&_-9=!+?>#DD"!'/]*,;_]9_UQ/=%]U;UX_ M7T]@7V%O_W;?8X]DGV6O9K]GSVC?:X___at_M]L#VT?;B]O/W!/""]SK_]\7PX? M#R^$7W8?=R]X/WE/_WI?>V^-'WV/?I]_KY+/@<__A'^#[YY_E]^''X_at_OB3^@ M[_^+7Y;OI<^.CX^?IZ^KGYO?_Y/?E.^5_ZT/F!^9+YH_FT__G%^=;Z`?N0^@
MGZ&OW!_=+]^\3__?`.\!_]XZ;[0`Y\`!XF!S='5M<&5DOBU``.3`YD^T8^3` M>>(PP]_0YB!L<#\_"Q\,+_^_SZ:/R<^LS\U_MK^NOZ_/_[#?L>_*K[0/M1_# M?[<_V$__NO^Z;]O_RN^]GZ./I)_>;__+O]1OP%^I[ZK_SB_I']!/_]%?TF_3M?^4OXVS),N2$\*__\;_6']<OVE_93_9_Y?_G#__H'>N/[)_MK^Z_[\_S__4/ M/_8?_"_X/P%/WU__at_9V-OX&QO<CTCPQ`*<N#D\C+A7V-FR3#=W\9/`O'_`)_\
MC_M&_E\#?P:O!9\3K__=#0PO#3\(G[Y_OX\9;^`11PKOW<_`;U-44N201X43 MBV(?R51O9&0C8/1H;\60<\>P#N\<O^0__^EO(C_J'R4O)C\I_RA?*J__&>H" MPQY?'V\O3QI/&U\RK_\KGRRO-K\WSSC?R)TAGBTO_P]/$%_]__\/`!\[SP(_ M$F__$W]`/Q6?+7\7OT5/,\__at_BO\+/TS_.;\ZSU'?^D_[7S\/_TDO02]"/T-/M4^]4_T9_1X__2K])KV%O2\],WTWO3O]0#_]1'V9_4S]=CV;?-$\U7VVO#QV/ MX3[B?."08VAI=/1E8\5P<L?0#9_'1".A:76P:&X*$6?%0'>P8?YM:T]L7VUO M>0]Z'WLO<H__<Y]Q'WO??.]7WV'_6?];#_]<'X-/@8]?3V!?8X]B?XWO_V2? M9:]^/V\?<"^2OW[/?]\-@.U(C!#@H',@4'7,8FR:P'6`;F>!WX+O_XI?F_^= M#YX?,`^8?X#?GG__GX^0?X4?AB^'/XA/B5^D?_^+?XR/C9^.KX^_D,^1WZWO M?Y/_E0^6'[:_F#^CWU41-F8SO<#%X&5N=:"O8$1!X*!V92P_at_3@HP9N$*$&L@ M5D&^T'8OKU+@,C,U,#*E'Z8OK9__P;_"S\/?NO^\#[F/Q(_%G_^GG[&_J;^J MSZO?R__*/Z\/_[`?LT^R/]:?M%^U;\;OMX\_N)_;;\=_R(_)G7>P;#H`(#<U M-RXT-37@+C4T,S153U9?5VHA(']34$%.U)1C;`!A<W,].#<W,^7I8#?+4"TR MVR`]0`IQ_]9/YM_<O]W/WM_K_^#_X@__TY"_K]2_RT_2O_1O]7_VC_\\ZNA! M^)_YK_?O^[_\S_W?__[O[]_P[\F/`F_LW^WOUS5X1F%XXV#S#_02XX8S_C#1 MP/^/`)\!KPQ?#6_-#__7+\\OT#_13Q`_#G_4?]6/_^JOUZ\:W]G/VM\%WP;O MZ,#Q>`%R/2/J(>HA`[\>C&$%&T5M86GC4><O0448U&AU\&8](B7R=`!O.G1T M:&]M<+!S;T!B=7":DW";`%(N(E!M(B.<:>-`9`T;XF8K,)M@<W1[2`!94$52 M3$E.2V8@*"\I/GU],A$K,'+&<QQ0'N$Q7'5HP!M(ORT_*;46OQ%O']\])4$: M@/\.SP_?,^\V3S=?$H\3GQ2O_Q6_.E\@'C[//]\8/QE/&E__.P\<?T+OY-_E M[SM?/&\]?Q=!3T)?0VLU(2$O0D\D1%DUS3(W3[%(5%Q-3#7-O?!$5'U5T``>
M`'```0```"P```!344P_at_475E<GD@=&\@8V]M8FEN92!M=6QT:7!L92!R;W=S M(&EN=&\@,2`_``(!<0`!````%@````'`WZ(LN_T!+(A+BA'5CT``4-IK_1@` M``,`)@```````P`V```````+``(``0````,`"5D"`````P#>/Z]O``!``#D` M8'D'*Z+?P`$#`/$_"00``!X`,4`!````"0```%142$]-4%-/``````,`&D`` M````'@`P0`$````)````5%1(3TU04T\``````P`90``````#`/T_Y`0```,` M@!#_____`@%'``$````U````8SU54SMA/2`[<#U"0TA!4E))4U!50CML/59)M4S`P,2TP,3`U,3_at_Q,S4U,39:+30P.34Y.``````"`?D_`0```$L````````` MW*=`R,!"$!JTN0@`*R_A@@$`````````+T\]0D-(05)225-054(O3U4]15_at_O M0TX]4D5#25!)14Y44R]#3CU45$A/35!33P``'@#X/P$````/````5&AO;7!S M;VXL(%1O9&0``!X`.$`!````"0```%142$]-4%-/``````(!^S\!````2P`` M``````#<IT#(P$(0&K2Y"``K+^&"`0`````````O3SU"0TA!4E))4U!50B]/
M53U%6"]#3CU214-)4$E%3E13+T-./5142$]-4%-/```>`/H_`0````\```!4 M:&]M<'-O;BP_at_5&]D9```'@`Y0`$````)````5%1(3TU04T\`````0``',!*[ MD#&AW\`!0``(,$!;?"NBW\`!'@`]``$````!`````````!X`'0X!````+```M`%-13"!1=65R>2!T;R!C;VUB:6YE(&UU;'1I<&QE(')O=W,@:6YT;R`Q(#\` M'@`U$`$```!`````/#)%139!-3`W,D)%0T0T,3$Y0D8X,#!!,$,Y04(R03_at_R M-C0W,T$T0'9I<S`P,2YB8VAA<G)I<W!U8BYC;VT^``L`*0``````"P`C```` M```#``80250B'@,`!Q#M`0```P`0$``````#`!$0`0```!X`"!`!````90`` M`$E614=/5$%324U03$5404),15=)5$@R0T],54U.4SI)1$%.1%)%3$%424]. M15A)1%)%3$%424].+2TM+2TM+2TM+2TQ,C-304TQ,C-"3T)"63$R,T1!3DDR M,S1-05)9,C,T0TD``````@%_``$```!`````/#)%139!-3`W,D)%0T0T,3$Y M0D8X,#!!,$,Y04(R03_at_R-C0W,T$T0'9I<S`P,2YB8VAA<G)I<W!U8BYC;VT^ #`-$Y
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 18 2001 - 10:15:16 CDT
 |
 |