Update columns from another table

  • Thread starter Thread starter robert.bezdicek
  • Start date Start date
R

robert.bezdicek

I cannot seem to find out how to update columns in table
(a) from table (b) in Access 2002. I do it rather simply
in SQLServer however I am having trouble doing it in
JETSQL.

The SQLServer SQL I am trying to simulate in Access looks
like this:
UPDATE t
SET t.bkup = s.bkup, t.bkup_ver = s.bkup_ver
FROM match_hdw_billable t, TSM s
WHERE t.hostname = s.hostname
GO
 
You might try something like this:

UPDATE
match_hdw_billable AS t
INNER JOIN
TSM AS s
ON
t.hostname = s.hostname
SET
t.bkup = s.bkup,
t.bkup_ver = s.bkup_ver
 
thanks...I really appreciate your response.
-----Original Message-----
You might try something like this:

UPDATE
match_hdw_billable AS t
INNER JOIN
TSM AS s
ON
t.hostname = s.hostname
SET
t.bkup = s.bkup,
t.bkup_ver = s.bkup_ver


"(e-mail address removed)"
Click to expand...
 
Back
Top