Hi bro i dont know how to do this query..

[Sasmi]

:confused:I want to create an query in which i want to show the data out put as show below is it possible? Database: Northwind Table : Products ProductId CategoryID 1 1 1 2 1 3 Output should be coma delimited as shown below. ProductID CategoryID 1 1,2,3 Thanks in advanced:rose: Sasmi

[pmarfleet]

Did you search Google[^]?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Xmen Real]

try JOIN function

Becoming Programmer...

[Marek Grzenkowicz]

This[^] can help, if you are using SQL Server 2005. And next time please give your message a more descriptive subject.