SELECT AvatarName AS "Fathers", AvatarName AS "Mothers"

FROM MegaAvatar, MegaAvParents, SuperAvatar, Avatar

WHERE MegaAvatar.MegaAvID=MegaAvParents.MegaAvID
AND MegaAvParents.FatherID=SuperAvatar.SuperAvID
AND MegaAvParents.MotherID=SuperAvatar.SuperAvID
AND SuperAvatar.SuperAvID=Avatar.AvatarID;

AND MegaAvParents.FatherID=SuperAvatar.SuperAvID
AND MegaAvParents.MotherID=SuperAvatar.SuperAvID

SELECT father.AvatarName AS "Fathers", mother.AvatarName AS "Mothers"

FROM MegaAvatar, MegaAvParents, SuperAvatar sFather, SuperAvatar sMother, Avatar father, Avatar mother

WHERE MegaAvatar.MegaAvID = MegaAvParents.MegaAvID
AND MegaAvParents.FatherID = sFather.SuperAvID
AND MegaAvParents.MotherID = sMother.SuperAvID
AND sFather.AvatarID = father.AvatarID
AND sMother.AvatarID = mother.AvatarID;