帮忙看看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方面的幫助