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

Text File | 1991-08-01 | 423b | 13 lines

INSERT INTO KeyChanger (oldreg#, oldoutlet#,
                        newreg#, newoutlet#)
SELECT Upd1.reg#, Upd1.outlet#,
       Upd2.reg#, Upd2.outlet#
  FROM UpdateList Upd1, UpdateList Upd2
 WHERE ( (Upd1.action = "B") AND (Upd2.action = "C"))
   AND ( (Upd1.name = Upd2.name)
   AND (Upd1.street = Upd2.street)
   AND (Upd1.city = Upd2.city)
   AND (Upd1.state = Upd2.state)
   AND (Upd1.zip = Upd2.zip));