Richard Van Wasshnova wrote: > SELECT tblIR.IDIR, tblIR.Surname, tblIR.GivenName, tblIR.BirthSD, > tblLR.Location, tblIR.ChrisSD, tblLR.Location, tblIR.DeathSD, > tblLR.Location, tblIR.Gender, tblIR.IDMRPref, tblIR.IDMRParents > FROM tblIR INNER JOIN tblLR ON (tblIR.IDLRDeath = tblLR.IDLR) AND > (tblIR.IDLRChris = tblLR.IDLR) AND (tblIR.IDLRBirth = tblLR.IDLR) > ORDER BY tblIR.Surname; > This query doesn't get "Location" for all 3, Birth", "Christening", > "Death"
You actually have to join tblLR 3 times using aliases. Here is a quick example... SELECT tblIR.Surname, tblIR.GivenName, tblLR.Location, tblLR_1.Location, tblLR_2.Location FROM ((tblIR INNER JOIN tblLR ON tblIR.IDLRBirth = tblLR.IDLR) INNER JOIN tblLR AS tblLR_1 ON tblIR.IDLRChris = tblLR_1.IDLR) INNER JOIN tblLR AS tblLR_2 ON tblIR.IDLRDeath = tblLR_2.IDLR; Good luck! -- Dennis M. Kowallek [EMAIL PROTECTED] ****************** Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter online at http://legacyfamilytree.com/FreeTrip.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ For online technical support, please visit http://www.legacyfamilytree.com/Help.asp To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
