1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
Contenus pertinents
- demandé il y a 6 mois
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
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