如何查找表t1中存在但表t2中不存在的所有记录?

我是想得出2个表中差异的那部分记录,类似与Python set() - set()那样的效果。不知道有没有简单的法子?

如t1:

attachments-2021-06-8fEFwD8N60cb0c9225235.jpg

t2:

attachments-2021-06-0MgrdFEG60cb0c97ec397.jpg

期望结果:

attachments-2021-06-IcQ4Ycze60cb0c9e29eaf.jpg

请先 登录 后评论

1 个回答

Juntao Wang
t1 = table(1 2 3 as id, `a `a `b as value)
t2 = table(1 2 2 as id, `b `a `c as value)
select * from lj(t1, t2, `id`value) where isNull(t2.id)
请先 登录 后评论