home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The C Users' Group Library 1994 August
/
wc-cdrom-cusersgrouplibrary-1994-08.iso
/
listings
/
v_02_09
/
2n09060a
< prev
next >
Wrap
Text File
|
1991-08-01
|
645b
|
21 lines
UPDATE UpdateList
SET action = "D"
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#))
AND (action = "B");
UPDATE UpdateList
SET action = "A"
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#))
AND (action = "C");