Hi all,

I have 2 tables ( table1 and table2) to become 1 single tableFinal but the structure is incremented .

table1.dbf ( 2 fields )

empno grade1
11111 10
22222 20
33333 30

table2.dbf ( 2 fields )

empno grade2
11111 11
22222 22
33333 33

How to create SQL statment in order to have tableFinal like this ?

TableFinal ( now 3 fields ) always order by empno.

empno grade1 grade2
11111 10 11
22222 20 22
33333 30 33

Thank you in advance for helping me out.