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 rTable2] where Country=“USA” in ATable1].

where FirmID is a one-to-many join.

Is there a way to do this in Airtable?

Thanks