Unexpected token in SQL [SOLVED]

[LinuxConvert2010]

I'm relatively new to OpenOffice and SQL. What exactly does an unexpected token mean in the context of creating a table from another table?

For example, I have written the following syntax (I've paraphrased with the table and column names) : CREATE TABLE TableName AS (SELECT Column1, Column2, Column 3 FROM TableName2);

When I run this or attempt to, I receive the following error message:

1: Unexpected token AS, requires ( in statement [CREATE TABLE TableName AS]

It does seem to be a syntax error, but I can't seem to resolve it. Any suggestions?

[RPG]

Hello

Study the HSQLDB manual for the syntax of the HSQLDB engine. Look good for the version. For better understanding SQL study an SQL tutorial. I think you should use the bultin tools. When you realy want use the commandline then you must realy study.

Romke