Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: (Newbie) Help with query.

Re: (Newbie) Help with query.

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 05 Jun 2003 15:28:12 GMT
Message-ID: <MPG.19490165e03512ad9897ab@news.la.sbcglobal.net>


nospam_at_nospam.com said...
> Hi,
>
> I'm not sure about how to accomplish the following query:
> Table A
> ======
> Date ts
> Number a
>
> Table B
> ======
> Date ts
> Number b
>
> I want to show A.ts, a, b , being b the first record (and only the first
> one) such as B.ts > A.ts
>
> Thanks in advance!
>
>
>

This is so simple, it MUST BE homework. What have you tried so far?

-- 
/Karsten
DBA > retired > DBA
Received on Thu Jun 05 2003 - 10:28:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US