How to fast table combine

[astech]

Hi All,

i have 2 table with same fieldname
tableA (code c(7)) and tableB (code c(7))
tableA has 500,000 records from 'A000000' to 'A500000'
and tableB has 400,000 records from 'A500001' to 'A900001'

How to fast combining both table in a corsor and knowing max code record ?

Thanks for help.

 

[Mike Gagnon]

astech

Take a look at APPREND FROM in the help file.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.