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: How to arrange this query ???

Re: How to arrange this query ???

From: sybrandb <sybrandb_at_gmail.com>
Date: 31 Jul 2006 01:07:47 -0700
Message-ID: <1154333267.918369.64510@s13g2000cwa.googlegroups.com>

etanto..._at_libero.it wrote:
> Good Morning,
> I need to extract some records from a table,
> another column have to be a boolean that tells me if the key of that
> record is present also in another table.
> It is possible to do all this with just one query ??
>
> Thanks,
>
> Antonio D'Ottavio
> www.etantonio.it/en/

Yes. Just use outer join.
However there is no such thing as a boolean in Oracle SQL.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 31 2006 - 03:07:47 CDT

Original text of this message

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