1 回答
- 最新
- 投票最多
- 评论最多
0
could you please share the SQL code you have in mind, so I can build an example?
Usually anti-joins and semi-joins can be replaced by other forms of joins and filters on the data.
So for example if you want to get all data from the join from the left table ( l) on l.key != r.key, you could use the left outer join and then add a filter on r.key is null. Thank you
相关内容
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
could you please share the SQL code you have in mind? Usually anti-joins and semi-joins can be replaced by other forms of joins and filter on the data. Thank you