Re: Can I getting a unique ID from a select

On Thu, Mar 01, 2007 at 06:16:02 -0800,
  Timasmith <timasmith@hotmail.com> wrote:
> I am using hibernate, using a view like a read only table and I need a
> primary key each time a select is issued.
>
> create view myview as
> select rownum, t1.field, t2.field
> from tableOne t1, tableTwo t2
> where t1.key = t2.fkey
>
> select * from myview
>
> But what I really need is
>
> select makemeauniquekey, t1.field, t2.field
> ...

Is there some reason you can't use the join key?