Re: cunning SQL query required

From: muppet <arc_at_hatecoffee.freeserve.co.uk>
Date: Tue, 6 Mar 2001 18:57:53 -0000
Message-ID: <Kqap6.1178$JS4.245890@news2-win.server.ntlworld.com>

"Mathew" <sheemat_at_yahoo.com> wrote in message news:3AA52B78.90303_at_yahoo.com...
> Hope I understood this correctly.
> If use an inline view to get the "current" view of the table, that
> probably should help
>
> thats
> select <whatever>
> from
> (select oid,status from table1 A
> where time = (select max(time) from Table1 B where A.oid=B.oid)))
> where condition.
>
> Will this work?

I was having trouble getting my head round the reflexive joining and kept getting either nothing or everything returned.

cheers, you've definitely won a pint if you're ever near Cambridge UK. Received on Tue Mar 06 2001 - 12:57:53 CST