[koha-es] Diferentes valores

[Luis Moises Rojas]

Tengo estos dos reportes:

1.
Select location Sala, count(DISTINCT biblionumber) AS TITULO,
count(itemnumber) AS EJEMPLARES
from items
where homebranch = 'BIJRD'
and withdrawn='0'
GROUP by location,homebranch
[image: image.png]

2.
Select location Sala, count(DISTINCT biblionumber) AS TITULO,
count(itemnumber) AS EJEMPLARES
from items
where homebranch = 'BIJRD'
and withdrawn='0'
GROUP by location,homebranch
[image: image.png]


Los títulos deberían de dar iguales, pero la diferencia es de mas de 1,000.
y es practicamente lo mismo.

Donde esta el error?

Gracias

-- 
*Luis Moisés Rojas P.*
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://lists.koha-community.org/pipermail/koha-es/attachments/20200731/59275cf0/attachment.htm>
------------ próxima parte ------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 2966 bytes
Desc: no disponible
URL: <http://lists.koha-community.org/pipermail/koha-es/attachments/20200731/59275cf0/attachment.png>
------------ próxima parte ------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 7304 bytes
Desc: no disponible
URL: <http://lists.koha-community.org/pipermail/koha-es/attachments/20200731/59275cf0/attachment-0001.png>