Update from second table

[Paul Dionne]

I am trying to update the values of one table based on a second table where
the LogonNames are identical in both tables.

UPDATE memSecurity INNER JOIN tmptblSecurityImport ON memSecurity.LogonName
= tmptblSecurityImport.LogonName SET memSecurity.ExpDate =
tmptblSecurityImport.ExpDate;

Works in MSAccess but not in SQL7. What am I overlooking?

Paul Dionne

[Jason Rein]

Simple syntax problem here. In SQL, the SET clause comes before the JOINs
and you have to specify the tables in a FROM clause.

UPDATE memSecurity
SET ExpDate = tmptblSecurityImport.ExpDate
FROM memSecurity
INNER JOIN tmptblSecurityImport ON memSecurity.LogonName
= tmptblSecurityImport.LogonName

- Jason

"Paul Dionne" <P-IHATESPAM-Dionne@Kreative.net> wrote:
>I am trying to update the values of one table based on a second table where
>the LogonNames are identical in both tables.
>
>UPDATE memSecurity INNER JOIN tmptblSecurityImport ON memSecurity.LogonName
>= tmptblSecurityImport.LogonName SET memSecurity.ExpDate =
>tmptblSecurityImport.ExpDate;
>
>Works in MSAccess but not in SQL7. What am I overlooking?
>
>Paul Dionne
>
>
>

[Paul Dionne]

Thanks, it worked

Jason Rein wrote in message <38df7bf2@news.devx.com>...
>
>Simple syntax problem here. In SQL, the SET clause comes before the JOINs
>and you have to specify the tables in a FROM clause.
>
>UPDATE memSecurity
>SET ExpDate = tmptblSecurityImport.ExpDate
>FROM memSecurity
>INNER JOIN tmptblSecurityImport ON memSecurity.LogonName
>= tmptblSecurityImport.LogonName
>
>- Jason
>
>"Paul Dionne" <P-IHATESPAM-Dionne@Kreative.net> wrote:
>>I am trying to update the values of one table based on a second table
where
>>the LogonNames are identical in both tables.
>>
>>UPDATE memSecurity INNER JOIN tmptblSecurityImport ON
memSecurity.LogonName
>>= tmptblSecurityImport.LogonName SET memSecurity.ExpDate =
>>tmptblSecurityImport.ExpDate;
>>
>>Works in MSAccess but not in SQL7. What am I overlooking?
>>
>>Paul Dionne
>>
>>
>>
>