Can you give a more detailed example with actual data? And please describe the relationships linking your tables?
Don't see any connection between "fieldname" in Table 1 to the results you specify at the end.
Even using SQL in other DB's requires join clauses to document the relationships between your tables. We can't use SQL in FileMaker, but you still have that requirement which is set up in Manage | Database.