importing from multiple odbc tables into filemaker

[Cong]

I am trying import data from three tables into a filemaker database. The first and second tables are linked using fieldA and the second and third table ares linked using fieldB. With Access 2000, I created the query and pulled data from it without a problem. However, with Filemaker, I am not sure how to perform the same task. I believe I have to use the Inner Joins command in filemaker, but haven't figure out a way to use it. Can anybody help me out? Thanks.

[transpower]

Your best bet is to use MSQUERY and SQL.

[Cong]

Can you be a little more specific? I am trying to accomplish this using SQL, but am not sure what how to write the sql statement. Thanks for the help.