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

Home -> Community -> Usenet -> c.d.o.server -> How to write SQL statement.

How to write SQL statement.

From: Aung Aung <acmarcom_at_singnet.com.sg>
Date: 14 Sep 1998 09:57:57 GMT
Message-ID: <01bddfc8$4f664e80$7cdededd@aung.acmarcom.com.sg>


Hello,

I have one problem to retrieve data in one statement. It is as follows:

Table A.	col1	col2	col3
		A	X	100
		A	Y	200
		B	X	100

Table B.	A	X	10
		A	X	20
		A	Y	10
		A	Y	20
		B	X	50

I would like to have the result as
		A	300	60 (A,300 from Table A, 60 from Table B)
		B	100	50 (B,100 from Table A, 50 from Table B)

Thank you,

Aung. Received on Mon Sep 14 1998 - 04:57:57 CDT

Original text of this message

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