Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to arrange this query ???
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 DBAReceived on Mon Jul 31 2006 - 03:07:47 CDT