[AOVKSA]

hey all,
ok this is my situation

Inside my database: myp_smooth i have the tables of 2 scripts.

Script ones user system is: table name: USERS, with the fields: USER_NAME, USER_ID and PASSWORD

Script two is: Table name: USER with the fields: USERNAME, USERID and PASSWORD

Now
I want to copy the data from USERS (user_name,user_id,password) and dump it to: USER (username,userid,password)

Because my mysql knowledge is limited i dont know how to insert data from a table with different variables then the other.

Helps would be highly appreciated

thanks