A Join query

Hello everybody

I use Filemaker 9 pro.
I've  a filemaker DB with some tables joined by relationships
I need to recover data in a way that in SQL is called "join query",
with a where clausole.

For example

Table Employee - Name, Surname, IdOrder
Table Order - idOrder, Item, Shipment, Country

SQL Statement
SELECT Name, Surname, Item, Shipment
FROM Employee INNER JOIN [Order] ON Employee.[IDOrder] = Order.
[IDOrder] WHERE Country="USA";

I need a Filemaker Format (report) in which I can see field Name,
Surname, Item, Shipment WHERE Country =USA.

How can I do?
Any suggestion?

Best regards