I’ve been using MySQL more than what I would like to. In these endeavors, I’ve always felt the need for one thing: Negated joins. For example, in a many-to-many, I want to know what
post is not linked to.
For those who had similar problems, I present you two solutions:
- MySQL 5.0 Reference Manual :: 184.108.40.206. EXISTS and NOT EXISTS
- Doing INTERSECT and MINUS in MySQL: classical use-left-join-to-find-what-isn’t-in-the-other-table
Thank you so very much!