[Koha-bugs] [Bug 20754] Db revision to remove double accepted list shares
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Apr 6 11:06:03 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20754
--- Comment #5 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
We usually use the following syntax to remove duplicated rows:
DELETE t1 FROM table_1 t1
LEFT JOIN table_2 t2 on t1.id=t2.id
WHERE t2.id IS NULL;
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list