Hello all,
apologies in advance for a rather long email.
We are trying to refine our late serials report and are having some problems with the results data.
Our report returns 200 results but only 20 of the results have title and bib number information, the remaining results have no title or bib number (blank cells) and only serial sequence of the late issue, planned date, serial ID and subscription ID. By using the serial ID to trace back and examine the serials with missing title info I find that most of them are "closed" subs but a few are genuine "open" subs with late issues expected. I can find no problem with the bib record or sub record of these titles, so why are they not appearing in the report with title and bib number information?
Here below is the SQL of the report; note that if I change the LEFT JOIN to simply JOIN the report returns only the 20 results with full title info, but what about the genuine results with missing title that do have late issues?
Any suggestions most welcome.
Thanks & regards,
Philip
Report SQL:
SELECT b.biblionumber, b.title, s.serialseq, s.planneddate, s.serialid, s.subscriptionid
FROM serial s
LEFT JOIN biblio b USING (biblionumber)
WHERE s.planneddate < CURDATE() AND s.STATUS NOT IN ('1','2')
Philip Bertling
Library Technician
Library
[cid:logo_2_44d690de-8900-4005-856c-10b45c4e3142.gif]
Royal Botanic Gardens Victoria
Birdwood Avenue
Melbourne Victoria 3004
T +61 3 9252 2382<tel:+61%203%209252%202382>
Philip.Bertling(a)rbg.vic.gov.au<mailto:Philip.Bertling@rbg.vic.gov.au>
rbg.vic.gov.au<http://www.rbg.vic.gov.au/>
[cid:Facebook_262bd55f-acb1-4241-885d-aeca54d786cf.gif]<https://www.facebook.com/BotanicGardensVictoria/> [cid:Twitterlogo_0239f90c-b285-48e4-b395-f0ebad856f0f.jpg] <https://twitter.com/RBG_Victoria> [cid:Instagramlogo_1bc60a46-7ae4-482c-b6ce-3162b19f9931.jpg] <https://www.instagram.com/royalbotanicgardensvic/>
We acknowledge the Traditional Custodians of the land on which we work and learn and pay our respects to their Elders past, present and future.
This email and any attachments may contain information that is personal, confidential, legally privileged and/or copyright. No part of it should be reproduced, adapted or communicated without the prior written consent of the sender and/or copyright owner. It is the responsibility of the recipient to check for and remove viruses. If you have received this email in error, please notify the sender by return email, delete it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information contained in this email. Please consider the environment before printing this email.
