Re: How to create the SELECT script?
From: Belakimem <belakimem_at_aol.com>
Date: 12 Aug 1998 09:21:46 GMT
Message-ID: <1998081209214600.FAA18723_at_ladder01.news.aol.com>
Date: 12 Aug 1998 09:21:46 GMT
Message-ID: <1998081209214600.FAA18723_at_ladder01.news.aol.com>
I don't know Oracle SQL very well, but in Informix it would be something like :
select table1.acc_no,table1.acc_nm,sum(table2.amt) total
from table1,table2
where
table1.acc_no=table2.acc_no
group by table1.acc_no
I think that is sufficiently generic to not worry about Informix/Oracle
differences.
get the picture?
Received on Wed Aug 12 1998 - 11:21:46 CEST