How to query two tables with a linked record?

Hello,
Can someone help to create this query in Airtable?

Table 1 fields are:
FirmID
Firm
Country

Table 2 fields are:
Firm ID
Firm
Contact Name

Find all “Contact Names” from [Table2] where Country=“USA” in [Table1].
where FirmID is a one-to-many join.

Is there a way to do this in Airtable?
Thanks

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.