I'll apologize ahead of time because I know I won't get the terminology correct in this question...

This is using Access 2000

I have a query that I need to build in an already existing database, the SQL for this query has 2 seperate JOINS. When I import this query from one database to another I don't have any problems. However, when I try to do the Query building through code (or even adding a new query in the database) I get an error message stating that the "JOIN expression is not supported."

If anyone has any ideas on how I can do this I'd really appreciate it.