home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,996 of 2,288   
   Nerfherder to All   
   Inner join with where   
   07 Feb 05 01:20:39   
   
   From: nobody@home.com   
      
   I have the following SQL statement I need to   
   add a secondary where clause to   
      
   SELECT name, amount   
   FROM node, log   
   WHERE log.name (+) = node.name   
      
   Now I need to add run_date = '31-JAN-05',   
   I can not just add this statement since when I do   
   loose columns in the node table since there is   
   not a 1:1 match between the two tables.   
      
   -- 	   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca