Re: Better way to do this

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 18 Jun 2003 10:03:29 +0100
Message-ID: <3ef02ae1$0$18495$ed9e5944@reading.news.pipex.net>

I'd suggest something like

select ...
from
t_history a,t_history b
where a.c_id=b.c_id
and a.end_date=b.start_date;

you may not have enough conditions in the eg above.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

"Steve J." <none_at_none.com> wrote in message
news:2dNHa.122740$G_.109981_at_news02.bloor.is.net.cable.rogers.com...


> That's what I'm looking for..can I have a small piece of code. I need more

> clue on the condition

>

>

>

>

>

> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message

> news:o5iuev80q1o7qq8fhlfo5vjqc3oeem6edi_at_4ax.com...

> > On Tue, 17 Jun 2003 00:21:37 GMT, "Steve J." <none_at_none.com> wrote:

> >

> > >This audit table has dozens of columns need to be returned  in same way

> in

> > >one returning cursor, is there a better way?

> >

> >

> > forget about the inline view, try to learn ordinary sql, and code a

> > *normal* join.

> >

> >

> > Sybrand Bakker, Senior Oracle DBA

> >

> > To reply remove -verwijderdit from my e-mail address

>

>

Received on Wed Jun 18 2003 - 04:03:29 CDT