Update a table using another table

[daniel_5191]

<%
dim str ,
str= "UPDATE backup SET backup.bid=login.userid , backup.bpass=login.userpassword,"
str=str & " backup.bname=login.username FROM backup , login WHERE backup.bid=login.userid"

con.execute str
%>
I try to UPDATE the backup table using the login table
Database : Access
Language : ASP
IE Error Problem : Syntax error (missing operator) in query expression 'login.username FROM backup'.


Thank you for your help . I am newbie in SQL and ASP too . Admin , can write me some example to do that ? Thank you .

[administrator]

Change the statement to this and it should work:

str= "UPDATE backup SET backup.bid=login.userid , backup.bpass=login.userpassword,"
str=str & " backup.bname=login.username FROM login WHERE backup.bid=login.userid"



Cheers,
_________________
Peter
ASP & ASP.NET Articles and Tutorials

[x-raysteve]

This is a bit confusing.

Is the purpose of this to just create a complete backup of the original table? Or is the backup table different in some way?

[paul]

These are 2 different tables, and the SQL statement just updates some of the fields from the first table using values from the second. Of course there must be a common field between the two tables in order to perform meaningful update.
_________________
World Countries | Survival Skills