RE: simple 4gl programme

Posted in 2000

Robert Stuart — Wed, 29 Nov 2000 11:22:42 -0000 — source: Informix-list mailing list archive (1991-1998)

Your request is a little confused (tired?). Assuming you want to change table_1.name ... UPDATE table_1 SET table_1.name = ( SELECT table_2.name FROM table_2 WHERE table_2.course = table_1.course ); DO NOT DO THIS ON LIVE DATA WITHOUT TESTING!! -----Original Message----- From: Simbarashe.Pangeti@icl.com [mailto:Simbarashe.Pangeti@icl.com] Sent: 29 November 2000 08:00 To: kagel@bloomberg.net; informix-list@iiug.org Subject: simple 4gl programme pple i am having problem s or may be i am tied because i have been working the whole night problem i have two tables and what i want is to take a unique value(column) from table 2 and put it in table 1 example table one name regno course simba 34 ff arts 35 tt iwe 23 dd table two name regno course simba 34 aa arts 35 mm iwe 23 dd so i want a script that will run for three thousand records and update course to a value in table2 eg course in table one to aa ie basically copying column course in table two to table one [deleted]