drjimwalsh1 skriver:

>
>
> Does that mean that I can't use the ORDER BY clause at all?
>
> I tried using the ORDER BY clause with an explicit column name, e.g.
> ORDER BY LastName
>
> That ran without an explicit error, but the result is incomplete. It
> shows only a small fraction of the table.

Odd. I thought views didn't support order by at all. If that's correct,
it should complain at view creation time, not accept the DDL and then
return incorrect or incomplete results.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64