帮忙看看jet sql 为啥报错？
SELECT F.FLOW_ID

FROM
T_FY_ZJJL_MASTER AS M LEFT JOIN T_XT_FLOWRECORD AS F
ON (F.FLOW_ID in (SELECT MAX(FLOW_ID) FROM T_XT_FLOWRECORD C WHERE C.CONTRACTSEGMENT_ID = M.CONTRACTSEGMENT_ID AND C.APPLY_CODE = M.APPLY_CODE AND F.OPERATION_NO = '3010 ' ))

[解决办法]
sql语句有问题，将记录及正确结果贴出来
[解决办法]
SQL Server用的是T-SQL,Access用的是Jet-SQL，真看一下Access中SQL方面的助