Vincenzo Scarpellino wrote:

>
>
> When I do a simple view of it I get a order data natural but I need order by
> Primary Key. How can I do it in a View?
>

select <select field list> from <view> order by <order field list>

You can't specify a sort order in a view definition. It's not part of
the standard. Nor, for that matter, is it part of relational theory.
If you want data in a particular order, you have to ask for it in that
order. Relational database represent their data by name and value, not
by position.

Regards,


Ann