I am trying to update a field in a table with the value in a field from
another table.. This is the SELECT statment I've run to see the two values
side by side:
SELECT a.RESKEY, a.ROOMNUMB, a.CCFEE, b.DCARD
FROM webTableReservations a INNER JOIN
seattdata b ON b.DBEGIN = a.ARRIVE AND b.DROOM =
WHERE (a.CCFEE IS NULL)
What I am try to do is this..
UPDATE webTableReservations as a
SET a.CCFEE = b.DCARD
WHERE b.DBEGIN = a.ARRIVE AND b.DROOM = a.ROOMNUMB
Execept that when I try to run this SQL I get an "Incorrect Syntax Near
I've tried re-working the SQL statment a few different ways, but can't get
it to execute..