Re: Exception Report

Posted in 1992

Dave Snyder — Tue, 23 Jun 92 10:34:24 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting 3030... > I have a table which contains raw data and a table which contains valid > values for one of the columns column. > What I need to be able to do is be able to identify all rows which do not > have a corresponding value in my look up table (i.e. exception report). Using the infamous "stores" database, this select statement will display all orders that don't have a matching customer in the customer table. SELECT * FROM orders WHERE customer_num NOT IN (SELECT customer_num FROM customer); DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com