方法1、select * from (上面的sql) where FItemID in(select FItemID from 表A)
2、再加一个inner join即可
Se lect {t_ICItemCore}.FNumber,{t_ICItemCore}.FName,{t_Supplier}.FName,{PORequest}.*,{PORequestEntry}.*,[F_103],[F_102] From (({PORequest} Inner JOIN {PORequestEntry} ON {PORequestEntry}.[FInterID] = {PORequest}.[FInterID]) Left JOIN {t_Supplier} ON {t_Supplier}.[FItemID] = {PORequestEntry}.[FSupplyID]) Inner JOIN {t_ICItemCore} ON {t_ICItemCore}.[FItemID] = {PORequestEntry}.[FItemID] inner join 表A on {t_ICItemCore}.[FItemID] = {表A }.[FItemID] Where [PORequestEntry].FMRPClosed <> 1