Ls

dbIsam 3.30 (D6)

Several select into statements only add the records of the last statement.
select * into memory VHtmp from VH;
select * into memory VHtmp from VH;

I want to do this in a loop for the VH tables in different db's and add all
records to the memory table. First I thought that I could use for the second
and later loops the INSERT INTO statement but there are more then 100 fields
and I guess that then I must type all the fields. Or is there a better way
to do this in in SQL?

Regards, Harry

Got it already. Sorry for asking

Regards, Harry

"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:2D27D951-9A15-46B6-A0B0-9497E2F90977@news.elevatesoft.com...
> Ls
>
> dbIsam 3.30 (D6)
>
> Several select into statements only add the records of the last statement.
> select * into memory VHtmp from VH;
> select * into memory VHtmp from VH;
>
> I want to do this in a loop for the VH tables in different db's and add
all
> records to the memory table. First I thought that I could use for the
second
> and later loops the INSERT INTO statement but there are more then 100
fields
> and I guess that then I must type all the fields. Or is there a better way
> to do this in in SQL?
>
> Regards, Harry
>
>