I need to create a report of Tagged persons that includes;
Marriage Date Groom Bride Groom Father Groom Mother Bride Father Bride Mother But I am at a loss on the way to do the joins so that I get the correct results. Here is my initial select SELECT MarSD, IDIRHusb, (HusbSurname, HusbGivenName,) AS Groom IDIRWife, ()WifeSurname, WifeGivenName,) AS Wife (H.HusbSurname, H.HusbGivenName,) AS Groom_Father, (H.WifeSurname, H.WifeGivenName) AS Groom_Mother, (W.HusbSurname, W.HusbGivenName) AS Wife_Father, (W.WifeSurname, W.WifeGivenName) AS Wife_Mother from tblMR WHERE IDIR.Tag1 = 1 Can any SQL expert help with the correct way to extract the right info? Thanks in advance for any help Jay Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp