title: How to copy data between 2 tables with an extra field in first table which has to be updated by a default value?
body: <p>I have 2 tables
  Table NAME (id, name, phone, city, state, rid)
  Table NAMES2 (id, name, phone, city)</p>
  
  <p>This SQL statment is not working:
  INSERT INTO NAME (id, name, phone, city, rid) VALUES ((SELECT id, name, phone, citY from NAMES2 WHERE city="Bangalore"),'72')</p>
  
  <p>I want rid field in Table NAME to have 72 for all the records inserted from table NAMES2.
  Note: both the tables are not identical.</p>