第一个查询
SELECT IT_NO, EVALUATEMEMBER
FROM REQUIRE_ESTI
WHERE (EVALUATEMEMBER <> '洪福亮') AND (IT_NO = '240718')
第二个查询
SELECT FLOWSN, ATTACH_NAME
FROM Require_deal
WHERE (ATTACH_TYPE = '7')

我把他们分开查询都可以编译通过,查询出结果,但是我把他们联合查询就不行了,其中他们相连接的条件是IT_NO=FLOWSN

SELECT REQUIRE_ESTI.IT_NO, REQUIRE_ESTI.EVALUATEMEMBER, ss.FLOWSN,
ss.ATTACH_NAME
FROM REQUIRE_ESTI
WHERE REQUIRE_ESTI.EVALUATEMEMBER <> '洪福亮' AND
REQUIRE_ESTI.IT_NO = '240718' INNER JOIN
(SELECT FLOWSN, ATTACH_NAME
FROM Require_deal
WHERE Require_deal.ATTACH_TYPE = '7') ss ON
REQUIRE_ESTI.IT_NO = ss.FLOWSN

会提示说在关键字'INNER'附近有语法错误

ss是什么？在REQUIRE_ESTI下有ss.FLOWSN, ss.ATTACH_NAME字段吗？