INSERT INTO qa_costpriceslog (item_code, invoice_code, item_costprice) SELECT /* Literal number values with column aliases */ 1 AS item_code, 2 AS invoice_code, item_costprice FROM qa_items WHERE item_code = 1;