Posted by Sherebiah on 05/04/06 14:13

Here is the answer for your question

select a.column1,
(select column2 from table where column1=a.column1),
(select column2 from table where column1=a.column1),
(select column2 from table where column1=a.column1)
from Table1 a

You need to have a single column in your table which can build
recursive relation.

• Next in forum: Re: Tuning on Oracle 10g and SQL Server 2005
• Prev in forum: Re: Partition function - Unknow range column
• Thread view: Re: Join multiple records into one field

[Reply to this message]