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