子查？!
SELECT NAME,NUM,ADDRESS FROM
(SELECT A.NAME.A,NUM,A.ADDRESS,B.DATE FROM
(SELECT NAME,NUM,ADDRESS FROM TABLEA ) A
INNER JOIN
(SELECT DATE,SAL FROM TABLEB) B ON XX XX XXX ) S
这个子查询，麻烦大家帮看下，提示没有为 S的数据行指定任何数据行，是为什么？该怎么改


[解决办法]
貌似没有问题
[解决办法]
要不就是还有什么东西没写..
[解决办法]
出在

SUM(SALARY) AS SALARY,0,SUM(ILL_HOUR)

有0指定列名

SUM(SALARY) AS SALARY,0 As aaaa,SUM(ILL_HOUR)

指定一名即可