Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jarimi

    How can I subtract result of 3 queries from a 4. query

    Thanks for your responses. I found the following solution to my problem. I tried using JOIN and EXCEPT, but it looks like the DB I'm quering is a limited version of DB2 without support of these commands.[mad] SELECT DISTINCT VOLUME_NAME FROM VOLHISTORY where volume_name not in (SELECT...
  2. jarimi

    How can I subtract result of 3 queries from a 4. query

    Please help me in making a SQL script for DB2 that Subtract result of 3 queries from a 4. query I would like to subtract results from query B,C,D from query result of A. The end result is a list of valid scratch tapes for free slots in a TSM tape robot. At the moment i'm using external...

Part and Inventory Search

Back
Top