dbTalk Databases Forums  

A little help with a query please

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss A little help with a query please in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DeanL
 
Posts: n/a

Default A little help with a query please - 06-25-2008 , 09:36 PM






Hi Guys,

I need a little help putting a query together as I'm pulling my hair
out. I'm getting two values, one from each table. Table 1 has a
value and is in a 1 to many relationship with table 2 so what I'm
getting back is something like this:

Table1.Col1 Table2.Col1
A 1
A 2
A 3
B 2
B 6
B 8
B 9

What I'm trying to get the query to do is this:

Table1.Col1 Table2.Col1
A 1,2,3
B 2,6,8,9

Can anyone help me on this before I finally rip all my hair out.

Many thanks, Dean...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.