topic Re: Query Tables and Joins in Archaeology GIS Questions https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779827#M16 <HTML><HEAD></HEAD><BODY><P>Do all of the points features have a related record&nbsp;match.&nbsp; Can you verify manually if there is a match for the missing records.&nbsp; &nbsp;And are the entries formatted EXACTLY the same&nbsp;</P></BODY></HTML> Thu, 27 Feb 2020 14:24:52 GMT RobertBorchert 2020-02-27T14:24:52Z Query Tables and Joins https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779824#M13 <HTML><HEAD></HEAD><BODY><P>I'm currently work on a project that connects a data sheet of artifact data to sites (polygon and points) already in Arcmap. I have used the make query table tool to connect the tables together by sites but there are sub sites&nbsp; so the table isn't exact and some points are missing because there are sub sites. Anyone have suggections on how I can fix this would be very much appreciated.&nbsp;</P></BODY></HTML> Tue, 25 Feb 2020 17:25:54 GMT https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779824#M13 Fitzpatrick_Natalie 2020-02-25T17:25:54Z Re: Query Tables and Joins https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779825#M14 <HTML><HEAD></HEAD><BODY><P>Make two connections.</P><P><BR />One to sites and one to sub sites.</P></BODY></HTML> Wed, 26 Feb 2020 15:45:33 GMT https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779825#M14 RobertBorchert 2020-02-26T15:45:33Z Re: Query Tables and Joins https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779826#M15 <HTML><HEAD></HEAD><BODY><P>Thank you for your help. I tried this and it seemed to work but the new layer created by the tool seems to be missing some of the sites that are point files.&nbsp; Anymore recommendations?</P></BODY></HTML> Wed, 26 Feb 2020 20:40:52 GMT https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779826#M15 Fitzpatrick_Natalie 2020-02-26T20:40:52Z Re: Query Tables and Joins https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779827#M16 <HTML><HEAD></HEAD><BODY><P>Do all of the points features have a related record&nbsp;match.&nbsp; Can you verify manually if there is a match for the missing records.&nbsp; &nbsp;And are the entries formatted EXACTLY the same&nbsp;</P></BODY></HTML> Thu, 27 Feb 2020 14:24:52 GMT https://community.esri.com/t5/archaeology-gis-questions/query-tables-and-joins/m-p/779827#M16 RobertBorchert 2020-02-27T14:24:52Z