UPDATE COMAND !HELP ME

[haibec]

Hi all!I have two table USER1 includes field : ID, Username,Password and Table USER2 includes filed : ID ,Username,Name . When user register . Data will save into 2 that table . One reason or other, two filed ID on the two table not same but Username on the 2 table same . I want UPDATE all ID on the User1 = ID on the User2 .Please help meeeeeeeeeeee

[Cronthenoob]

You'll have to do something likeINSERT into table1 set id='id', username='username'SELECT id FROM table1 where username='requested_username'INSERT into table2 set id='table1_id' username='requested_username'I'm not sure about the syntax because i've only worked with PHP and MySQL. But the queries would look similar.

[bhavik_solanki]

Try This QueryUpdate User2 Set UId = User1.Uid From User1 Where User1.UserName = User2.UserName

[iyeru42]

Try This QueryUpdate User2 Set UId = User1.Uid From User1 Where User1.UserName = User2.UserName

Assuming the person used the AS or LEFT JOIN deal of course. If not, that won't work since it'll say User1.uid is invalid, null or not an object.