两个表之间循环查询引发的血案~~~~~~~~~~~~~~ 本帖最后由 figomes 于 2012-05-08 18:46:46 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select TA.idx,SUM(TB.PRICE) AS AMOUNT from ta JOIN TB ON TA.IDX = TB.IDX where TA.type = 'xxx'GROUP BY TA.IDX select idx,price from tb where idx in ( select idx from ta where type = XXX ) orz 你俩结果一致 地球人已经无法阻止你们俩了 我怎么给分啊你们说 测试数据CREATE TABLE T194( idx NUMBER(4), MyType VARCHAR2(20));INSERT INTO T194 VALUES(1, 'A');INSERT INTO T194 VALUES(2, 'A');INSERT INTO T194 VALUES(3, 'A');INSERT INTO T194 VALUES(4, 'B');INSERT INTO T194 VALUES(5, 'B');INSERT INTO T194 VALUES(6, 'C');CREATE TABLE T195( idx NUMBER(4), Price NUMBER(4));INSERT INTO T195 VALUES(1, 10);INSERT INTO T195 VALUES(1, 20);INSERT INTO T195 VALUES(4, 30);INSERT INTO T195 VALUES(4, 40);INSERT INTO T195 VALUES(5, 50);INSERT INTO T195 VALUES(5, 60);测试结果:网站不能上传图片,自己执行一下吧。SELECT t1.idx, SUM(t2.price) AS amount FROM T194 t1 ,T195 t2WHERE t1.idx = t2.idx AND t1.MyType = 'B'GROUP BY t1.idx; 求高手看看啊 几个触发器 oracle试题 Oracle中Decode函数用法 还是刚才的删除重复数据问题 ORACLE的SQL语句运行没反应!请高手指点! 为什么不能用OB来debug pl/sql ┣┫请教关于编写trigger问题 救命呀!!!initialization or shutdown inprogress 错误如何解决 ,各位大虾帮帮忙把 如何,创建存储过程,下面这个有什么问题? sql写法,请指教! 求助各位高手哥哥姐姐弟弟妹妹 数据库连接方式的选择
GROUP BY TA.IDX
where idx in (
select idx from ta
where type = XXX )
(
idx NUMBER(4),
MyType VARCHAR2(20)
);INSERT INTO T194 VALUES(1, 'A');
INSERT INTO T194 VALUES(2, 'A');
INSERT INTO T194 VALUES(3, 'A');
INSERT INTO T194 VALUES(4, 'B');
INSERT INTO T194 VALUES(5, 'B');
INSERT INTO T194 VALUES(6, 'C');CREATE TABLE T195
(
idx NUMBER(4),
Price NUMBER(4)
);
INSERT INTO T195 VALUES(1, 10);
INSERT INTO T195 VALUES(1, 20);
INSERT INTO T195 VALUES(4, 30);
INSERT INTO T195 VALUES(4, 40);
INSERT INTO T195 VALUES(5, 50);
INSERT INTO T195 VALUES(5, 60);
测试结果:
网站不能上传图片,自己执行一下吧。SELECT t1.idx, SUM(t2.price) AS amount
FROM T194 t1 ,T195 t2
WHERE t1.idx = t2.idx AND t1.MyType = 'B'
GROUP BY t1.idx;