Re: How to create the SELECT script?

From: Vilmantas Sviklas <vsviklas_at_it.ot.lt>
Date: Thu, 13 Aug 1998 08:51:27 +0200
Message-ID: <6qu2a3$kmd@tauras.vu.lt>

Violin wrote in message <35da3558.2858616_at_news.twsc.pouchen.com.tw>...
>Hello,
>My database is Oracle 7.3
>I have 2 tables are:TABLE1 is master,TABLE2 is detail.
>And the data is:

...
>
>I wonder how to return the result:
>List all rows of master TABLE1,and count sum(AMT) of TABLE2.
>But if I use the clause:WHERE TABLE1.ACC_NO=TABLE2.ACC_NO,

You need to write:

WHERE TABLE1.ACC_NO=TABLE2.ACC_NO(+) and then you will get what you want.

Vilmantas Received on Thu Aug 13 1998 - 01:51:27 CDT