I have the following report: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated ORDER BY biblio.title ASC But it only returns information if there are item records attached, what I really want is a list of everything catalogued. A lot of our biblios don't have items attached. What's the best way to do this? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Elaine, I have the following report:
SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated ORDER BY biblio.title ASC
But it only returns information if there are item records attached, what I really want is a list of everything catalogued.
It does that because you begin you query with items table. Perhaps this modified query could help you, but without homebranch information SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated FROM biblioitems LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated ORDER BY biblio.title ASC; Regards, Bernardo
Thanks, I was patching together two reports into one and missed that crucial bit! Elaine On Mon, Jun 3, 2013 at 7:02 PM, Bernardo Gonzalez Kriegel < bgkriegel@gmail.com> wrote:
Elaine, I have the following report:
SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated ORDER BY biblio.title ASC
But it only returns information if there are item records attached, what I really want is a list of everything catalogued.
It does that because you begin you query with items table. Perhaps this modified query could help you, but without homebranch information
SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated FROM biblioitems LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated ORDER BY biblio.title ASC;
Regards, Bernardo
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
participants (2)
-
Bernardo Gonzalez Kriegel -
Elaine Bradtke