Table question

A beginner question about tables - need advice....

I first created one table with several columns and populated rows with data.
Next I created a second table and copied several columns from the first table into the second one...so far looks ok. now I like to add one more column to the second table from the first one (including data in that column) using syntax below:

modify table second_table
add ( select column from first_table);

is there another way to do it or maybe the table can only have blank columns (not null) added to the second table? Received on Wed Feb 17 1999 - 17:53:12 CST