[RESOLVED] Oracle query

[sniper]

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:

select * 
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 
				) a
 	 )
WHERE r BETWEEN 1 and 195 order by r;

[chazzy]

have you begun by verifying that your data is still correct?