25 Feb
2019
25 Feb
'19
7:35 a.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22368 --- Comment #29 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Martin Renvoize from comment #26)
(In reply to Jonathan Druart from comment #23)
NOT IN could (must?) be replaced with LEFT JOIN table SET attr_a = NULL WHERE attr_b IS NULL
Personally, I always find the NOT IN clearer than a LEFT JOIN.. and I thought the performance was pretty much the same as the mysql optimiser accounts for it.
I do find the NOT IN syntax more readable too.. -- You are receiving this mail because: You are watching all bug changes.