方法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
加好友 
发短信
Post By：2020/7/5 20:57:00 [显示全部帖子]
