[Koha] Koha 16.05 - SQL Report on Koha Control Numbers - Finding blank 001s

[Craig Butosi]

Hi all,

Koha 16.05 o Ubuntu 14.04 LTS
Package install

Would a kind soul help me with a basic SQL report which compiles a list of all bibliographic records that have a blank 001, but which have a biblionumber? Columns selected for the report = biblionumber, title, author.

I have tried a number of queries but can't seem to get the syntax correct.

Many thanks!

Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
the royal conservatory
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca<http://www.rcmusic.ca/>



Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.