How to insert into table in XML which has more than table?

Insert into mysql from another table with a where clause.?

• I am working on a mysql database. I have two tables, one is the Booking table and the other is user table. Users fill in a form under a session and their username(uname) is saved onto the Booking table in the database. This table has another column by the name of ref, that provides user ref. I want to get that value from my user table by comparing the username as equal to the one recorded in the Booking table. Hope this makes sense :) Here is the command I'm trying to use: INSERT INTO Booking (`ref`) SELECT FROM user ('ref') WHERE (SELECT FROM Booking (‘uname’))= (SELECT FROM user (‘uname’))

• Answer:

  Hmm, it should be something like that, TBH I think it's not what you wanted, but the way you explained it didn't really help. INSERT INTO `Booking` (`ref`) VALUES (SELECT `id` FROM `users` WHERE `uname`='user name');