Alter table

[tezread]

Hi guys

What on earth is wrong with this:

SELECT * INTO NewTable
FROM qry_car_reqtoproc_crosstab
ALTER TABLE NewTable ADD COLUMN ReportComments TEXT(25);


I get ......
Syntax error in FROM clause. (Error 3131)

You entered an SQL statement that has an invalid FROM clause.

Possible causes:

• A reserved word or argument name is misspelled or missing.
• Punctuation is incorrect.

 

[boblarson]

Change to this:

SELECT qry_car_reqtoproc_crosstab.* INTO NewTable
FROM qry_car_reqtoproc_crosstab

And then you have to do the Alter Table and run it separately.