$sql = '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;';