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

2003-12-07 10:38:51 168 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

hanhanprogramer 墨衍会员 · AI 创作全网分发关注 + 加入社区

AI使用指南：6个超实用的Prompt提示词模板最近越来越多人开始接触AI，但其实想要让AI更懂你，关键是掌握对的提示词模板！今天就给大家分享6种超实用的Prompt提示词模板，不管你是小白还是老手都能用阅读详情

在视图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语句来实现查询的目的啊？？？如果能的话应该怎么写啊？如果能解决分不够的话可以加！！！

...全文

从零开始：用ADS 2023手把手教你设计2.4GHz Wi-Fi LNA（基于ATF-54143，附模型文件）本文详细介绍了如何使用ADS 2023软件设计2.4GHz Wi-Fi频段的低噪声放大器(LNA)，基于ATF-54143晶体管。内容涵盖模型导入、直流工作点确定、稳定性优化、噪声匹配等关键步骤，并提供可下载的模型文件包，帮助工程师快速掌握LNA设计技巧。阅读详情

hanhanprogramer

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

bflovesnow 2003-12-07

打赏
举报

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

bflovesnow 2003-12-07

打赏
举报

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

CrazyFor 2003-12-07

打赏
举报

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

wzh1215 2003-12-07

打赏
举报

--或用已有的视图连也行！
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'

wzh1215 2003-12-07

打赏
举报

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'

azsoft 2003-12-07

打赏
举报

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'

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

相关推荐

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