vendredi 13 mai 2016

display multiple values from two tables in one row in sql server

I have the following two tables

TableA           Table B

id               bid  bname     btitle
1                1    john      titlejohn
2                1    william   titlewilliam
3                1    george    titlegeorge
                 2    bill      titlebill
                 3    kyle      titlekyle
                 3    seb       titleseb

I need a query in sql server which displays the following output:

id   name                     title
1    john,william,george      titlejohn,titlewilliam,titlegeorgw
2    bill                     titlebill
3    kyle,seb                 titlekyle,titleseb

Please help.

Aucun commentaire:

Enregistrer un commentaire