MySQL 三表联合插入语句示例 - 将商品从特定仓库出库
INSERT INTO tab_outbound (o_gid, o_wid, odate, outbound, outmoney) SELECT gid, wid, CURDATE(), gnumber, gnumber*gprice FROM tab_goods JOIN tab_warehouse ON 1 WHERE gcategory = '电脑' AND wname = '仓库A'
原文地址: https://www.cveoy.top/t/topic/qqno 著作权归作者所有。请勿转载和采集!