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
|
Results 1 to 3 of 3
Thread: Insert Statement ?Threaded View
|
Click Here to Expand Forum to Full Width |