On Thu, Mar 01, 2007 at 06:16:02 -0800,
Timasmith <timasmith(at)hotmail(dot)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?