SELECT a.ID, a.Name, b.ID, b.Name, b.Relationship FROM tbl_Name AS a
INNER JOIN tbl_Dependents AS b ON b.ID=a.ID
Example
tbl_Name
ID|Name----------|
1 |James Hinrich
2 |Larch Hamster
3 |Johann Bach
tbl_Dependents
UID|ID|Name-------------|Relationship
1--|1 |Owen Hinrich------|Son
2--|1 |Rebecca Hinrich---|Daughter
is it possible to display them in listview on single line?
like this
ID|Name---------|Dependent 1--|Relationship 1|Dependent 2-----|Relationship 2|
1 |James Hinrich--|Owen Hinrich--|---- Son----|Rebecca Hinrich---|---Daughter