sql server2014插入语句提示select附近语法错误

Question

INSERT INTO DBO.order_hj (FBILLNO,FULLNAME,PRODUCT_SORT)
VALUES (SELECT T1.FBillNo,T2.FullName,T3.Product_sort FROM edw1_fact_sal_order T1
LEFT JOIN dim_customer T2
ON T1.FCustID=T2.ItemID
LEFT JOIN dim_product T3
ON T1.FProduct_Code=T3.Product_code);
单独执行select语句没有问题，数据类型和长度我都设置成一样了，麻烦帮忙看一下

Answer 1

注意语法，不要加values，和插入一条数据的sql混了

[sqlserver]SELECT INTO 和 INSERT INTO SELECT - 飘阳小果 - 博客园 1.INSERT INTO SELECT语句 语句形式为：Insert into Table2(field1,field2,...) select value1,value2,... from Tab https://www.cnblogs.com/piaoyangguoguo/p/8276928.html