_______________________ allows you to select the values from another table or from the list of values.This is a fill up

_______________________ allows you to select the values from another t

1.	_______________________ allows you to select the values from another table or from the list of values.This is a fill up
Answer» As the TITLE says, I am trying to INSERT into one table SELECTING values from another table and some default values.INSERT INTO def (catid, title, page, publish) (SELECT catid, title from ABC),'page','yes')INSERT INTO def (catid, title, page, publish) VALUES((SELECT catid, title from abc),'page','yes'))The first query gives a mysql error and the second one gives column count does not match.