Display data horizontally from DB

[Andrzejek]

If I have data in TableA:[tt]
ProjectNumber
ABCD[/tt]

TableB:[tt]
ProjectNumber AnotherField
ABCD xyz[/tt]

As long as I have just one (or none) record in TableB, I can ask for this data:

Select ProjectNumber || ' ' || 
([blue]Select AnotherField from TableB
Where TableB.ProjectNumber = TableA.ProjectNumber[/blue]) As MyProjNo
From TableA

And I get displayed:[tt]
MyProjNo
ABCD xyz[/tt]

But I have this in TableB:[tt]
ProjectNumber AnotherField
ABCD xyz
ABCD ggg
ABCD klm
ABCD opq[/tt]

And I want to have displayed:[tt]
MyProjNo
ABCD xyz ggg klm opq[/tt]

Any ideas?

(Data base is Oracle)


Have fun.

---- Andy

 

[RiverGuy]

I'm sure you could do something, but you might want to ask this specifically in one of the Oracle forums. I've written code in SQL Server to accomplish that exact task a few times, but the code is very proprietary to SQL Server.

 

[Andrzejek]

Thank you, I will post it again in Oracle group.

Have fun.

---- Andy

 

[neemi]

have you tried a crosstab type query?

 

[Andrzejek]

The answer to my question is here for those who want to know.

Have fun.

---- Andy