On Mon, 21 Dec 2009 09:00:55 -0600, Robert Carneal USA <[email protected]> wrote:
>I would like to make a list of individuals who have a UNSPECIFIED >field being sourced. Is that possible please? SELECT tblIR.IDIR AS RIN, tblIR.Prefix, tblIR.GivenName, tblIR.Surname, tblIR.Title FROM tblSX INNER JOIN tblIR ON tblSX.IDIME = tblIR.IDIR WHERE tblSX.Type=0 or UPDATE tblSX INNER JOIN tblIR ON tblSX.IDIME = tblIR.IDIR SET tblIR.Tag1 = 1 WHERE tblSX.Type=0 -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
