31 Jul
2020
31 Jul
'20
9:36 p.m.
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.*
