CREATE TEMPORARY TABLE tmp (partnumber varchar(30), qty_instock varchar(5), DESCRIPTN varchar(50), partnumberWH varchar(30), qty decimal(30,9)) ENGINE = MEMORY;
INSERT INTO tmp (partnumber, qty_instock, DESCRIPTN) SELECT STOCK.PARTNUMBER, STOCK.QTY_INSTOCKCOND, STOCK.DESCRIPTN FROM STOCK WHERE STOCK.PARTNUMBER LIKE '%234%';
INSERT INTO tmp (partnumberWH, qty) SELECT STOCKWH.PARTNUMBER, STOCKWH.QTY FROM STOCKWH WHERE STOCKWH.PARTNUMBER LIKE '%234%';
SELECT * FROM tmp;