From: laconic2@comcast.net   
      
   "robert"  wrote in message   
   news:da3c2186.0405250459.28ffbb6b@posting.google.com...   
      
   > (still doesn't explain why  value  could ever be NULL; i've restricted   
   > to matching on order_number in both tables.  all order_lines have   
   > a  value )   
      
   I didn't catch this point the first time around.  Did you say this earlier?   
      
   Test your data to make sure this is true.  Maybe there's something about the   
   data that's different than what you expect.   
      
   Also,  take a look at Oracle's execution plan to make sure that it's not   
   doing an outer join, for some reason.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)