请大家帮忙看看我的sql语句！

[19820911]

SELECT Code,
(SELECT SUM(yearbudget) AS A, SUM(yearbudget) AS B
FROM T_LargessBudgetTotal WHERE PRJFUNCode = a.Code)
FROM T_PRJFUNCode
WHERE (LEN(REPLACE(Code, '.', '')) = LEN(Code) - 1) AND (Code LIKE '1.%') AND
(Code <> '1.')

为什么这句话不行，我要怎么改呢？
SELECT Code,
(SELECT SUM(yearbudget) AS A, SUM(yearbudget) AS B
FROM T_LargessBudgetTotal WHERE PRJFUNCode = a.Code)
FROM T_PRJFUNCode

[ghostzxp]

SELECT a.Code,SUM(b.yearbudget) AS A,SUM(b.yearbudget) AS B
FROM FROM T_PRJFUNCode a ,T_LargessBudgetTotal b
WHERE b.PRJFUNCode = a.Code

[yingxiangchen]

可以试试用UNION，但每个查询中的列数和顺序都要一致才行