我还要关联另外一个表,取其中一个字段,作了个视图,这样写的查询,查不出来就超时了:(
SELECT RIGHT(txmd_rktj.cpbh, 5) AS cpgg, SUM(txmd_rktj.zms) AS zms,
ymj.txmd_pbsjy.ylgg
FROM txmd_rktj INNER JOIN
ymj.txmd_pbsjy ON SUBSTRING (txmd_rktj.cpbh, 4, 4) = ymj.txmd_pbsjy.pbbh AND
txmd_rktj.mdbh <> '1600000000' AND txmd_rktj.mdbh <> '1700000000'
GROUP BY RIGHT(txmd_rktj.cpbh, 5), ymj.txmd_pbsjy.ylgg