I got a problem with a insert statement. I have two table such as :
in first table (Mscat) i have a data :
User CategID CategName
B 1 Budy
B 2 Rudy
C 3 Heny

In second table (TmpMscat) i have a data :
User CategID CategName
D 5 Wani
D 6 Runi
E 7 Yuki
E 8 Lucky

Then I use statement : insert into TmpMscat select * from Mscat where user = B

When I run and result is like that
D 5 Wani
D 6 Runi
B 1 Budy
E 7 Yuki
E 8 Lucky
B 2 Rudy

But I want data to be insert into table at last record or like that :
D 5 Wani
D 6 Runi
E 7 Yuki
E 8 Lucky
B 1 Budy
B 2 Rudy

So Anyone can help me ?


Best Regard's

Long