topic SQL query on different Filemaker tables into ArcMap in Developers Questions https://community.esri.com/t5/developers-questions/sql-query-on-different-filemaker-tables-into/m-p/246474#M1543 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm a newbie in the GIS world and I have few problems dealing with connections between my Filemaker database (version11, .fp7) and ArcMap.</P><P>I could connect it to ArcGIS without&nbsp;problem trough an OLE DB connection and now the different tables appear into my content. But of course, all the relationships (one-to-many)&nbsp;disappeared.</P><P>Now&nbsp;I would like to do selections by attribute using fields of different tables. Let's say I have a table with natural sites and their attributes, an other with the animal found on these sites and their attributes, and a shapefile with polygons of the sites.</P><P>How can I select, for example, the sites that where&nbsp; protected after 1980 and where we found white wolve?</P><P></P><P>I can do that with <EM>Make Query Table, </EM>it worked, but I have a lot of datas and the resulting table start to be too big. Is there any way to keep the one-to-many relationships between the tables and to make an SQL statement?</P></BODY></HTML> Tue, 10 Oct 2017 14:57:51 GMT MajaMarkovic 2017-10-10T14:57:51Z SQL query on different Filemaker tables into ArcMap https://community.esri.com/t5/developers-questions/sql-query-on-different-filemaker-tables-into/m-p/246474#M1543 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm a newbie in the GIS world and I have few problems dealing with connections between my Filemaker database (version11, .fp7) and ArcMap.</P><P>I could connect it to ArcGIS without&nbsp;problem trough an OLE DB connection and now the different tables appear into my content. But of course, all the relationships (one-to-many)&nbsp;disappeared.</P><P>Now&nbsp;I would like to do selections by attribute using fields of different tables. Let's say I have a table with natural sites and their attributes, an other with the animal found on these sites and their attributes, and a shapefile with polygons of the sites.</P><P>How can I select, for example, the sites that where&nbsp; protected after 1980 and where we found white wolve?</P><P></P><P>I can do that with <EM>Make Query Table, </EM>it worked, but I have a lot of datas and the resulting table start to be too big. Is there any way to keep the one-to-many relationships between the tables and to make an SQL statement?</P></BODY></HTML> Tue, 10 Oct 2017 14:57:51 GMT https://community.esri.com/t5/developers-questions/sql-query-on-different-filemaker-tables-into/m-p/246474#M1543 MajaMarkovic 2017-10-10T14:57:51Z