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)

SELECT biblio.biblionumber, title, isbn, issn FROM biblio LEFT JOIN biblioitems USING(biblionumber) LEFT JOIN items USING(biblionumber) WHERE itemnumber is NULL