阅读背景:

Oracle SQL:从另一个表向查询结果添加sum

来源:互联网 

I have two tables where one of the tables, TABLE2, has a column for TABLE1_IDs, thus there is a many-to-one relationship between TABLE2 and TABLE1 rows. TABLE2 has a column PRICE which is a number that represents a dollar amount. I have a query that obtains certain rows of TABLE1, but I want to get the total of all corresponding TABLE2 rows' PRICE values as an additional column in the query results.I have two tables where one of the tables, TABL




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: