[Koha-bugs] [Bug 20754] Db revision to remove double accepted list shares

[bugzilla-daemon at bugs.koha-community.org]

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.