Creating a new table as a subset of two other tables

[carter.cleveland]

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

[Neil]

Since you have two tables, you need to specify the fields. Select table1.*,
table2.* From... However, you will probably get more fields than you want
that way, since you have the cusip field in both tables. Better to specify
the fields: Select table1.field1, table1.field2, table2.field1, etc.

Neil

<ca**************@citi.comwrote in message
news:11*********************@m36g2000hse.googlegro ups.com...

>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