SQL查询语句的问题，有一定的难度，高手请进！！！ 急~~~~~~~~在线等待

[hanhanprogramer]

在视图VIEW_wholesale_export_memos中有如下SQL语句
SELECT SUM(quantity) AS quantity, drug_code, batch_no, wholesale_export_no
FROM wholesale_export_memos
GROUP BY drug_code, batch_no, wholesale_export_no

在视图VIEW_memos-strike中有如下SQL语句
SELECT b.export_no, a.strike_quantity, e.quantity, a.drug_code
FROM strike_export_memos a INNER JOIN
strike_export_main b ON a.strike_export_no = b.strike_export_no INNER JOIN
VIEW_wholesale_export_memos e ON b.export_no = e.wholesale_export_no AND
a.drug_code = e.drug_code AND a.batch_no = e.batch_no AND a.dispose_result <> '2'
最后需要一个简单的SQL语句来达到查询的目的
例如：select * from VIEW_memos-strike where a.strike_quantity <> e.quantity
请问高手：这样的东东能不能用一句SQL语句来实现查询的目的啊？？？如果能的话应该怎么写啊？如果能解决分不够的话可以加！！！

[azsoft]

SELECT b.export_no, a.strike_quantity, e.quantity, a.drug_code
FROM (SELECT SUM(quantity) AS quantity, drug_code, batch_no, wholesale_export_no
FROM wholesale_export_memos
GROUP BY drug_code, batch_no, wholesale_export_no)
a INNER JOIN
strike_export_main b ON a.strike_export_no = b.strike_export_no INNER JOIN
VIEW_wholesale_export_memos e ON b.export_no = e.wholesale_export_no AND
a.drug_code = e.drug_code AND a.batch_no = e.batch_no AND a.dispose_result <> '2'

[wzh1215]

SELECT b.export_no, a.strike_quantity, e.quantity, a.drug_code
FROM strike_export_memos a INNER JOIN
strike_export_main b ON a.strike_export_no = b.strike_export_no INNER JOIN
(
SELECT SUM(quantity) AS quantity, drug_code, batch_no, wholesale_export_no
FROM wholesale_export_memos
GROUP BY drug_code, batch_no, wholesale_export_no
) e
ON b.export_no = e.wholesale_export_no
where a.drug_code = e.drug_code AND a.batch_no = e.batch_no
AND a.dispose_result <> '2'

[wzh1215]

--或用已有的视图连也行！
SELECT b.export_no, a.strike_quantity, e.quantity, a.drug_code
FROM strike_export_memos a INNER JOIN
strike_export_main b ON a.strike_export_no = b.strike_export_no INNER JOIN
VIEW_wholesale_export_memos e ON b.export_no = e.wholesale_export_no
where a.drug_code = e.drug_code AND a.batch_no = e.batch_no
AND a.dispose_result <> '2'

[CrazyFor]

select * from VIEW_memos-strike where strike_quantity not in (select quantity from VIEW_wholesale_export_memos)

[bflovesnow]

select * from VIEW_memos-strike v1 where not exists (select 1 from VIEW_wholesale_export_memos v1 where v1.strike_quantity=v2.quantity)

[bflovesnow]

select * from VIEW_memos-strike v1 where not exists (select 1 from VIEW_wholesale_export_memos v2 where v1.strike_quantity=v2.quantity)