select D.Item_Data from flow_run_data D Inner join ( SELECT D.RUN_ID, ITEM_DATA FROM flow_run_data D INNER JOIN flow_run R ON R.Run_ID = D.Run_ID AND flow_id =58 WHERE D.Item_ID =5 AND item_Data in($query的SQL语句) ) A on D.Run_ID=A.Run_ID where D.Item_ID=21
select D.Item_Data from flow_run_data D Inner join ( SELECT D.RUN_ID, ITEM_DATA FROM flow_run_data D INNER JOIN flow_run R ON R.Run_ID = D.Run_ID AND flow_id =58 WHERE D.Item_ID =5 AND item_Data =(SELECT Item_Data,R.Run_ID,R.FLOW_ID FROM flow_run_data D INNER JOIN flow_run R ON R.Run_ID = D.Run_ID AND flow_id =58 where D.Item_ID=5 and Item_Data !=') ) A on D.Run_ID=A.Run_ID where D.Item_ID=21
(
SELECT D.RUN_ID, ITEM_DATA
FROM flow_run_data D
INNER JOIN flow_run R ON R.Run_ID = D.Run_ID
AND flow_id =58
WHERE D.Item_ID =5
AND item_Data in($query的SQL语句)
) A on D.Run_ID=A.Run_ID where D.Item_ID=21
(
SELECT D.RUN_ID, ITEM_DATA
FROM flow_run_data D
INNER JOIN flow_run R ON R.Run_ID = D.Run_ID
AND flow_id =58
WHERE D.Item_ID =5
AND item_Data =(SELECT Item_Data,R.Run_ID,R.FLOW_ID FROM flow_run_data D INNER JOIN flow_run R ON R.Run_ID = D.Run_ID
AND flow_id =58 where D.Item_ID=5 and Item_Data !=')
) A on D.Run_ID=A.Run_ID where D.Item_ID=21