SELECT * FROM tblFamily ; WHERE iParentID == m.iID>Query 2 returns the parent of EVERY child. I need it to return just the ancestors of a child with a given iID.
SELECT tblChild.iID AS C_iID, ; tblChild.iParentID AS C_iParentID, ; tblChild.cInfoAndStuff AS C_cInfoAndStuff, ; tblParent.cInfoAndStuff AS P_cInfoAndStuff ; FROM tblFamily tblChild ; INNER JOIN tblFamily tblParent ; ON tblChild.iParentID == tblParent.iID ; <b>WHERE tblChild.iID == m.iID</b>>Thanks again for your help.