www.webdeveloper.com
Results 1 to 2 of 2

Thread: [RESOLVED] Oracle query

  1. #1
    Join Date
    Nov 2005
    Posts
    109

    resolved [RESOLVED] Oracle query

    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:
    Code:
    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;

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    have you begun by verifying that your data is still correct?
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles