Syntax error in CREATE TABLE

[roger06]

I have an issue wherein the number of fields(columns) in a table exceed 255 in MS Access.ie(370)
So i decided to split the tables into 2 diferent table each containing 185 fields.

Then before running the QTP script, I join the 2 tables and store them as a view. View is a virtual table
and I am assuming it can hold any number of fields.

I tried the following syntax

create view as select * from table1 INNER JOIN table2 ON table1.ROW_NUMBER=table2.ROW_NUMBER

Where table1 and table2 are tables and row_number is a common field.I am not familiar with MS ACCESS.
Am I on the right track and is the syntax right?

I am getting the following error
"Syntax error in CREATE TABLE"

can u pl help me.Its urgent...