Visual Tools for DB2

By Gary Bist

Dr. Dobb's Sourcebook May/June 1997

SELECT DISTINCT serialwkg, incnum, duedate, description
   FROM incident i, empserv e
   WHERE i.serialwkg=e.serial
      AND duedate > '1996-9-01'
      AND dept = 'S21'
   GROUP BY serialwkg, incnum, duedate, description
   ORDER BY serialwkg

Example 1: Sample query.

Back to Article