Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to write SQL statement.
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