Parent and Child table in one line
I want to combine and get one row from parent and child table in MSSQL 2008 query.
Parent Table ( person )
Full Name, Age, DOB, Address
Child Table ( family member )
Full name, Given Name, Relationship, Nationality, Gender
So, I want them into one line like
Full Name, Age, DOB, Address, Fullname1, GivenName1, Relationship1, Nationality1, Gender1, Fullname2, GivenName2, Relationship2, Nationality2, Gender2, Fullname3, .... etc
Could you help me to explain if I must use Pivot? Or is there any other way to write the query?