一张表中数据几个字段的值添加到另一张表中的值

语法

INSERT INTO a(a1,a2)  SELECT  b1,b2 FROM b

实例

INSERT INTO pur_material (
NAME,
price,
amount,
money,
comedate,
origin
) SELECT
`name`,
order_price,
order_amount,
order_money,
come_date,
origin
FROM
store
WHERE
order_amount IS NOT NULL
AND
  order_amount !=0.00

INSERT INTO pur_material (
NAME,
price,
amount,
money,
origin,
comedate,
suppliername
)
SELECT
DISTINCT
s.`name`,
  s.order_price,
  s.order_amount,
  s.order_money,
  s.origin,
  s.come_date,
  s.supplier
FROM
store s
LEFT JOIN supplier su ON su.`name` = s.supplier
LEFT JOIN pur_supplier ps ON ps.`name` = su.`name`
WHERE
s.action = '入库'
AND 
  s.dr = 0
AND 
  s.order_amount is not NULL
AND 
  s.order_money != 0.0000