Hi, here is the statment
create view test_v as
select x, y from xy_table
order by x,y

[Edited by ocpdude on 11-08-2000 at 12:58 PM]