SELECT biblio.biblionumber, title, isbn, issn FROM biblio LEFT JOIN biblioitems USING(biblionumber) LEFT JOIN items USING(biblionumber) WHERE itemnumber is NULL
Comment trouver les notices bibliographiques sans exemplaires – (USING)
![](https://koha-fr.org/kohala/wp-content/uploads/2018/02/binary-2904980_1920.jpg)
SELECT biblio.biblionumber, title, isbn, issn FROM biblio LEFT JOIN biblioitems USING(biblionumber) LEFT JOIN items USING(biblionumber) WHERE itemnumber is NULL