I had this query working and I guess I must have made a minor change without noticing but now it's not returning anything.
Here's the query:
from ( select a.*, rownum r
from ( select P.PRINTERNAME, B.BUILDINGNAME, F.FLOORNAME, R.ROOMNAME, D.DEPARTMENTNAME
from PRINTER P, BUILDING B, FLOOR F, ROOM R, DEPARTMENT D, PRINTERLOCATION PL
WHERE PL.LANGUAGE = 'English'
AND P.PRINTERID = PL.PRINTERID
AND B.BUILDINGID = PL.BUILDINGID
AND F.FLOORID = PL.FLOORID
AND D.DEPARTMENTID = PL.DEPARTMENTID
AND R.ROOMID = PL.ROOMID
order by PL.PRINTERID
WHERE r BETWEEN 1 and 195 order by r;