Re: [Koha] Problem with some SQL

2021-03-16 Thread Guillermo
Hi Speak Spanish ? Ing. Guillermo González El lun., 15 de mar. de 2021 1:34 a. m., Carlos Lopez escribió: > Hi everyone > > I have the following reports that I would like to combine into one: > > SELECT categories.description, COUNT(borrowers.borrowernumber) > FROM borrowers, categories >

Re: [Koha] Problem with some SQL

2021-03-16 Thread Carlos Lopez
, VICTORIA 3052 Ph: 03 9340 ext.1 | libr...@dml.vic.edu.au<mailto:libr...@dml.vic.edu.au> | library.dmlibrary.org.au From: Koha on behalf of Sebastian Krieg Sent: Monday, 15 March 2021 6:40 PM To: koha Subject: Re: [Koha] Problem with some SQL Hello

Re: [Koha] Problem with some SQL

2021-03-15 Thread Sebastian Krieg
Hello, Try this to combine the query and exp2 and exp3: SELECT [] FROM [] WHERE exp1 AND (exp2 OR exp3) ORDER by [] ; I hope this works, I got no error executing this query in my database... Thanks Sebastian > Carlos Lopez hat am 15.03.2021

[Koha] Problem with some SQL

2021-03-14 Thread Carlos Lopez
Hi everyone I have the following reports that I would like to combine into one: SELECT categories.description, COUNT(borrowers.borrowernumber) FROM borrowers, categories WHERE borrowers.categorycode = categories.categorycode AND borrowers.date_renewed BETWEEN <> AND <> GROUP BY