Post reply

Records in n-Relation-Table in one Select-Statment

  • June 9, 2014 at 7:45 am

    #286403

    Hi,

    I have 2 tables in a 1: n relation. How can i get a select statement that the field in the n-relation with outputs, separated by a semicolon; Example: One person have many Job Titles

    Table1 (tblPerson)

    Table2 (tblTitles)

    1, "John", "Miller", "Employee; Admin; Consultant"

    2, "Joan", "Stevens", "Employee, Software Engineer, Consultant"

    and so on .... 1 in select statement:

    Regards

    Nicole 😉

  • June 9, 2014 at 8:02 am

    #1720089

    This article can help you accomplish what you're looking for:

    http://qa.sqlservercentral.com/articles/comma+separated+list/71700/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply