Z
zionsaal
I have one table called "ParentList" like this:
ParentID, FirstName, LastName, Address,
1001 John Duo 123 Main St.
1002 Cris Taylor 456 Maple St.
then I have a table called "Children" Like this:
ChildID, ParentID, ChildFirst,
1001 1001 Ab
1002 1001 Bryan
1003 1001 Dave
1004 1002 Jack
1005 1002 Bill
So I want the sql results Like this:
ParentID, FirstName, LastName, Address, Child(1), Child(2),
Child(3),
1001 John Duo 123 Main St. Ab
Bryan Dave
1002 Cris Taylor 456 Maple St. Jack
Bill
thanks in advance!!!!!
ParentID, FirstName, LastName, Address,
1001 John Duo 123 Main St.
1002 Cris Taylor 456 Maple St.
then I have a table called "Children" Like this:
ChildID, ParentID, ChildFirst,
1001 1001 Ab
1002 1001 Bryan
1003 1001 Dave
1004 1002 Jack
1005 1002 Bill
So I want the sql results Like this:
ParentID, FirstName, LastName, Address, Child(1), Child(2),
Child(3),
1001 John Duo 123 Main St. Ab
Bryan Dave
1002 Cris Taylor 456 Maple St. Jack
Bill
thanks in advance!!!!!