INSERT INTO SELECT statement with more columns which is not in another table

You could use default filler

  INSERT INTO TABLEB(col1, col2, col3, col4, col5) 
  SELECT col1, col2, col3, '', ''
  FROM TABLEA;

Now, instead of '' you could pass any variable, which you get from application side.

Browse More Popular Posts

Leave a Comment