select * from (select g.ProductListID as gp,l.ProductListId as lp from GenerateLog as l
left join GenerateProductList as g
on l.ProductListId = g.ProductListID) as t where t.gp is null
两个表查询,查出左表有的,但右表没有的数据
最新推荐文章于 2023-05-15 17:48:31 发布
select * from (select g.ProductListID as gp,l.ProductListId as lp from GenerateLog as l
left join GenerateProductList as g
on l.ProductListId = g.ProductListID) as t where t.gp is null