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: <etantonio_at_libero.it>
Date: 31 Jul 2006 02:28:42 -0700
Message-ID: <1154338122.917306.112290@m79g2000cwm.googlegroups.com>


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 Received on Mon Jul 31 2006 - 04:28:42 CDT

Original text of this message

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