mysql查询两列之和插入新表

记录一下卡了我一上午的小问题：

有A B两张表，A表的某一列是B表中的两列之和，现在要把B的两列之和插入到A中

insert into TBL_PASSENGER_FLOW_STATISTICS(station,enter_station,leave_station)
VALUES(
select station_id from TBL_PASSENGER_FLOW ,
SELECT ifnull(QR_IN_NUM,0)+ifnull(FACE_IN_NUM,0) from TBL_PASSENGER_FLOW ,
SELECT ifnull(QR_OUT_NUM,0)+ifnull(FACE_OUT_NUM,0)from TBL_PASSENGER_FLOW
);

我是这样写的，改来改去，一直报错
运行结果及报错内容 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘select station_id from TBL_PASSENGER_FLOW ,
SELECT ifnull(QR_IN_NUM,0)+ifnull(F’ at line 3

经过一位大佬指点，最终解决了

insert into TBL_PASSENGER_FLOW_STATISTICS(station,enter_station,leave_station)
select 
station_id, ifnull(QR_IN_NUM,0)+ifnull(FACE_IN_NUM,0), ifnull(QR_OUT_NUM,0)+ifnull(FACE_OUT_NUM,0) 
from TBL_PASSENGER_FLOW

不用values（），直接select就行，虽然不太清楚为什么，但是先继续往下进行了，有大佬留言指点下也不错哦！！！