How To Update A Field ?
From: Angelica Veron <Faro_at_globalserve.net>
Date: Sun, 27 Jun 1999 03:26:08 -0500
Message-ID: <3775E020.ADAD1F7B_at_globalserve.net>
Hello Everyone,
Date: Sun, 27 Jun 1999 03:26:08 -0500
Message-ID: <3775E020.ADAD1F7B_at_globalserve.net>
Hello Everyone,
UPDATE WrongTable
The above script updates Field 1 in Table 1 with the information of
Field 2 in Table 2 (both being of the same datatype). At the moment
Field 2 basically overwrites all existing data with it's own data, and
if it encounters data in Field 1 which it doesn't have an equivalent
update it just replaces it with a NULL value (ie. wipes out the original
SET WrongTable.employee_name = (
SELECT CorrectTable.employee_name
FROM CorrectTable
WHERE CorrectTable.employee_id = WrongTable.employee_id);
Yours Sincerely,
Angelica Veron,
Faro_at_globalserve.net
Received on Sun Jun 27 1999 - 10:26:08 CEST