查询高手来帮忙啊。 SELECT SUM(PRICE) FROM B,AWHERE A.ZLXMID='2756' AND A.SFXMID=B.SFXMID;已经给你调试了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum(price) from b,awhere b.sfxmid in (select a.sfxmid from a where = zlxmid )这不就搞定了吗 我自己已经搞定了,这个最简单了。不过,还是谢谢楼上的兄弟。select a.zlxmid,sum(b.price)from a,bwhere a.sfxmid=b.sfxmidgroup by a.zlxmid select a.zlxmid,sum(b.price)from a join busing(sfxmid)group by a.zlxmid select a.zlxmid,max(select sum(price) from b where sfxmid=a.sfxmid) from a group by zlxmid试试这个,还没测试过. 数据库问题? 执行拼接字符串的问题 求SQL。觉得比较麻烦的。。 请教ORACLE数据库表中同一字段互相赋值的问题 求一个触发器的写法.急.在线等待.. 求助:表中数据被sql语句误删如果利用日志恢复(oracle9i for nt) oci 读取数据时返回列为空错误 oracle表删除、并恢复后出现程序运行出现的问题? 两个数据库对象对比的程序(在线等待) 急......... ORA-06575程序包或函数FN_DLR_INDX_FULL_CD处于无效状态 请教:如何备份oracle数据库,小弟初学,有些搞不明白 一个SQL语句请教?
where b.sfxmid in (select a.sfxmid from a where = zlxmid )这不就搞定了吗
select a.zlxmid,sum(b.price)
from a,b
where a.sfxmid=b.sfxmid
group by a.zlxmid
from a join b
using(sfxmid)
group by a.zlxmid