Thanks David!!! this is awesome. Really helps...

There is no relationship between T1 and T2. T1 is column in Table1 and T2 is column in Table2.

Yes I want to display the data side-by-side. Is this possible?

Sorry the output I want is:::

T1 T2

- - - - - - -

300 600

400 700

Hi Adrian

Hope this helps:::

Use Pubs

Declare @TitleList Varchar(8000)

SELECT @TitleList = COALESCE(@TitleList + ', ', '') + au_fname FROM Authors

SELECT @TitleList

Thanks

Brij Rauthan