mysql-我想使用其他两个 tablw 的子查询插入，但我想按当前日期输入填充日期列

我的问题是：

INSERT INTO initial(`name`,`quantity`,`Date`)
select
  c.name AS Item_Name,
  b.Ibyinjiye - i.Ibyasohotse AS Current_Stock_QTY
from product as c
inner join (
  select
    productID,
    ifnull(sum(quantity),0) as Ibyinjiye
  from stockproduct group by productID
) as b on c.productID = b.productID
inner join (
  select productID,
  ifnull(sum(quantity),0) as Ibyasohotse
  from soldstock
  group by productID
) as i on c.productID = i.productID,CURRENT_DATE