The C Users' Group Library 1994 August/wc-cdrom-cusersgrouplibrary-1994-08.iso/listings/v_02_09/2n09059c

Text File | 1991-08-01 | 345b | 10 lines

CREATE VIEW NonKeyChanges
AS SELECT * FROM UpdateList
    WHERE EXISTS (SELECT *
                    FROM UpdateList Upd1, UpdateList Upd2
                   WHERE (Upd1.action = "B")
                     AND (Upd2.action = "C")
                     AND (Upd1.reg# = Upd2.reg#)
                     AND (Upd1.outlet# = Upd2.outlet#));