Concatenate ProductName and SubProductName separated by comma
Posted on 2011-02-17
I am not completely new to sql but not familiar with everything as well. I am stumbled with one problem which I thought was easy :)
Anyways, here is the senario:
I have two tables named Products and SubProducts. Each product is related to some SubProducts. What I am trying to accomplish is return ProductName and SubProductName in following manner.
.......hope you get the idea. so concatenate ProductName and SubProductNames that are related to that ProductName.
So row one would contain concatenation of first ProductName and it's related SubProductNames
Rows two would contain concatenation of second ProductName and it's related SubProductNames....
Any ideas/suggestions are highly welcome.
Thank you in advance for all you guys help :)