Insert Statement ?

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

You need to use an "order by" statment

When inserting, try:
insert into TmpMscat select * from Mscat where user = B order by user

When pulling from the table, try:
select * from TmpMscat order by user

Jay

I means not sort by.

In second table already have a data so when i insert, i want it's insert into last record


Long