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,801 of 2,288   
   Hans Forbrich to Dale DeRemer   
   Re: Missing from one table   
   04 Oct 04 22:45:14   
   
   From: news.hans@telus.net   
      
   Dale DeRemer wrote:   
      
   > We want to make a query where we check table A for employee numbers and   
   > compare that with table B. We would like to build a list of employees who   
   > are in table A but not in table B. An ideas on how to build that type of   
   > query?   
      
   Use the SELECT 'MINUS' capability.  (SELECT ... MINUS SELECT ...)   
      
   --- 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