日期:2014-05-18 浏览次数:20579 次
[code=SQL] INSERT INTO T_Temp ([year], [month], ProdCode, ChnCountryId,ie) SELECT [year]='2008',[month]= '12', T_HS.ProdCode, T_Country.chncountryid,T_IE.ie FROM T_HS CROSS JOIN T_Country CROSS JOIN T_IE
------解决方案--------------------
你的写法没有错.
INSERT INTO T_Temp([year], [month], ProdCode, ChnCountryId , ie) SELECT '2008', '12', T_HS.ProdCode, T_Country.chncountryid,T_IE.ie FROM T_HS CROSS JOIN T_Country CROSS JOIN T_IE