[Koha-bugs] [Bug 21901] Foreign keys are missing on the serials and subscriptions tables

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21901

--- Comment #26 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
DELETE FROM serial WHERE biblionumber NOT IN (SELECT biblionumber FROM biblio)

Wouldnt it be better to left join biblio here and check biblionumber is null in
the where condition ?
Same for another one.

-- 
You are receiving this mail because:
You are watching all bug changes.