insert into table_a (col1 ,col2)
select
(select top 1 col from table_b where ),
(select top 1 col from table_c where )
select
(select top 1 col from table_b where ),
(select top 1 col from table_c where )
调试欢乐多
SELECT
--Charges,Re数据来源是从3张表(Table_B, Table_C和Table_D)中分别Select的
(SELECT TOP 1 Iterm FROM Table_B) as Item,
(SELECT TOP 1 Charges FROM Table_C) as Charges,
(SELECT TOP 1 Re FROM Table_D) as Re,
--Date的数据来源是按Iterm加入数据为查询条件,Table_A最大日期再加1个月。
DATEADD(Month,1, (SELECT MAX(Date) FROM Table_A WHERE Item = (SELECT TOP 1 Iterm FROM Table_B)))