tags:

views:

38

answers:

1
Q: 

Most efficient way to query joined tables in Filemaker Pro 10

I am tasked with extracting data from 2 tables: Master and Charges. The common key is two alpha fields.

I need to filter the results by fields in each of the two tables-- Year and Office in the Master, and another alpha field in the Charges.

There are over a million master records, and about 4 charges for each on average.

The tables have come from a legacy system and are presently in Filemaker Pro Advanced version 10.

Once the filters are in place, I intend to export the data and further summarize the results in Excel, since I'm more familiar with that.

What is the most efficient way to join and filter this data?

+2  A: 

Define a relationship between the 2 tables, then do a find operation in the charges table. Be sure to allow indexing on the fields you're searching on, FileMaker should be able to do a relatively speedy search over the 4 million records if the fields are indexed.

Sam Barnum  2010-06-30 00:10:50
Does it matter where I define the relationship -- in the Master or Charges table?
George W  2010-06-30 16:07:46

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?