Re: How to arrange this query ???

From: sybrandb <sybrandb_at_gmail.com>
Date: 31 Jul 2006 02:49:14 -0700
Message-ID: <1154339354.734990.260910@b28g2000cwb.googlegroups.com>

etantonio_at_libero.it wrote:
> The tables in the database are the following :
>
> T1
> cod_dest
> descr_dest
>
>
> T2
> cod_dest
>
>
> in my select I need 3 columns
> T1.COD-dest , T1.DESCR-dest , 0 or 1 depending if T1.cod_dest is also
> present in T2.cod_dest.
>
> Can you help me to arrange such query ???
> many thanks
>
>
> Antonio D'Ottavio
> www.etantonio.it/en

You mean: I should do *your* work?
Read up on 'outer join' and at least *try* it yourself!!!!

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Mon Jul 31 2006 - 04:49:14 CDT