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
>
, 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
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
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
4 matches
Mail list logo