Creating a new table as a subset of two other tables

I am trying to create a table which is a subset of two other table
where those tables have the same uniquely identifying key. I am using
Access 2003.

The SQL statement that I am trying to use gets an automation error,
and I am not sure what part of the SQL code is causing them because I
don't know how to debug from the error statements that I get. Here is
the code:

CREATE TABLE subTable
AS (
SELECT *
FROM table1, table2
WHERE table1.cusip = table2.cusip)

cusip is the uniquely identifying key that each table contains. Can
anyone see what is causing the automation error?

Thanks,
Carter

.