问题相关代码
表格1查询:select mbl from passinfo where orderid='443140' and toolsindex='60'
表格2查询:select mbl from indata where orderid='443140'
运行结果内容
表格1查询显示列:mbl数量有2621个
表格2查询显示列:mbl数量有16608个
我想要达到的结果
对比表1和表格2,只显示表格1未包含的mbl个数13987。
表格1查询:select mbl from passinfo where orderid='443140' and toolsindex='60'
表格2查询:select mbl from indata where orderid='443140'
表格1查询显示列:mbl数量有2621个
表格2查询显示列:mbl数量有16608个
对比表1和表格2,只显示表格1未包含的mbl个数13987。
select mbl from passinfo where orderid='443140' and toolsindex!='60'
或者
select mbl from indata where orderid='443140' and mbl not in(
select mbl from passinfo where orderid='443140' and toolsindex='60'
)