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
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