51,410
社区成员
发帖
与我相关
我的任务
分享Select *
From 订单总表
Where 消费类型 = "IC卡"
And 订单ID Not In (
Select 订单ID
From IC储值卡支付的订单信息
)
select a.* from order a left join iczhifu b on b.order_id=a.order_id where b.order_id is null and a.order_type='IC卡支付';
SELECT * FROM order A WHERE NOT EXISTS (SELECT 1 FROM iczhifu B WHERE A.ORDER_ID = B.ORDER_ID)