count(itemnumber) AS EJEMPLARES
from items
where homebranch = 'BIJRD'
and withdrawn='0'
GROUP by location,homebranch
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
count(itemnumber) AS EJEMPLARES
from items
where homebranch = 'BIJRD'
and withdrawn='0'
GROUP by location,homebranch
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.