Re: where is the error?

Pier Gaetano Novara wrote:

> Ok is clear, but if I would like to do an icrement of the rowid to
> point the next row how could I do?
> I need to make a jouin using the same table 2 times:
> select
> ...
> from
> table a, table b
> where
> a.rowid=b.rowid+1

You need to understand what a ROWID is. There is no such concept in a heap table as "next row."

What is the business problem you are trying to solve.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)