...I hate when this happens, I found it.
For those who didn't know:
insert into table1 select table2.* from table2;
I know, I should be column specifc to accomodate table schema changes later
in life, but this was a test.
T
On Tuesday 27 November 2001 12:46 pm, Tony wrote:
> I thou
I thought the following SQL statement would work (both tables are the same
schema):
insert into table1 values ( select * from table2 ) ;
...or was I seeing magic posts in the wee hours of the morning? I didn't
think that was a subselect, but maybe I am wrong there too.
Any help
