sql在一张表中存在,不在另外2张表

在一张表中存在,不在另外2张表写法: select ISNULL(SUM(Amt),0) from A s WHERE s.CreateTime BETWEEN @from and @to AND s.TradeNo NOT IN ( select FlowNo from B1 WHERE Flow
posted @ 2020-10-03 23:00  *人丑就该多读书*  阅读(284)  评论(0编辑  收藏  举报