From: forbrich@yahoo.net   
      
   Charlie Bursell wrote:   
      
   > Using Oracle 8, so no ANSI joins   
   >   
      
   Just hints (perhaps others will be kind enough to work this with you)   
      
   a) Try writing it using ANSI joins and then look at the docco to map the   
   'ANSI' back to Oracle's outer join capability.   
      
   b) Ask yourself why you are still using Oracle8.  At least for test   
   purposes, you could create an Oracle9i or Oracle10g harness and check it   
   out. If this is a one-off question, possibly use that harness with DB links   
   back to the Oracle8 database.   
      
      
   /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)