Anonymous

$sql = 'CREATE TEMPORARY TABLE tmp (partnumber varchar(30), qty_instock varchar(5), DESCRIPTN varchar(50), partnumberWH varchar(30), qty decimal(30,9)) ENGINE = MEMORY;';
mysql_query($sql);

$sql = ' INSERT INTO tmp (partnumber, qty_instock, DESCRIPTN) SELECT STOCK.PARTNUMBER, STOCK.QTY_INSTOCKCOND, STOCK.DESCRIPTN FROM STOCK WHERE STOCK.PARTNUMBER LIKE \'%234%\';';
mysql_query($sql);

$sql = ' INSERT INTO tmp (partnumberWH, qty) SELECT STOCKWH.PARTNUMBER, STOCKWH.QTY FROM STOCKWH WHERE STOCKWH.PARTNUMBER LIKE \'%234%\';';
mysql_query($sql);

$sql = ' SELECT * FROM tmp;';
$result = mysql_query($sql);