insert as select

Ii there anybody to tell me why :

insert into rubriques
select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle from rubr r1
order by c

does not work, but :
insert into rubriques
select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle from rubr r1

works quit well !!!

whats wrong with the "order by" clause

thanks everybody

Eric from PARIS - FRANCE Received on Mon Apr 26 1999 - 03:50:37 CDT