Very Computer

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 =
a.ROOMNUMB
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
Keyword AS"

I've tried re-working the SQL statment a few different ways, but can't get
it to execute..

Thanks,

Rich

UPDATE webTableReservations
   SET CCFEE = (SELECT DCARD
                  FROM seattdata
                 WHERE seattdata.DBEGIN  = webTableReservations.ARRIVE
                   AND seattdata.DROOM = webTableReservations.ROOMNUMB)
 WHERE EXISTS  (SELECT *
                  FROM seattdata
                 WHERE seattdata.DBEGIN  = webTableReservations.ARRIVE
                   AND seattdata.DROOM = webTableReservations.ROOMNUMB)
   AND CCFEE IS NULL

In T-SQL you can also re-write this as:

UPDATE webTableReservations
   SET CCFEE = seattdata.DCARD
 WHERE seattdata.DBEGIN  = webTableReservations.ARRIVE
   AND seattdata.DROOM = webTableReservations.ROOMNUMB
   AND CCFEE IS NULL

--
- Anith
(Please respond only to newsgroups)

UPDATE webTableReservations
   SET CCFEE = seattdata.DCARD
  FROM seattdata
 WHERE seattdata.DBEGIN  = webTableReservations.ARRIVE
   AND seattdata.DROOM = webTableReservations.ROOMNUMB
   AND CCFEE IS NULL

--
- Anith
(Please respond only to newsgroups)

Thanks.. this seems to have worked..

Rich

Quote:> I made a mistake in the T-SQL version (#2), it should be:

> UPDATE webTableReservations
>    SET CCFEE = seattdata.DCARD
>   FROM seattdata
>  WHERE seattdata.DBEGIN  = webTableReservations.ARRIVE
>    AND seattdata.DROOM = webTableReservations.ROOMNUMB
>    AND CCFEE IS NULL

> --
> - Anith
> (Please respond only to newsgroups)