select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637' or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout where mater_no in (select mater_no from storein where in_no in('141638','141637','141557','141515','141516')
把等号改成in 就好了 select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout as a where exists(select 1 from storein where a.mater_no =mater_no and (in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516'))
select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select *
from storeout
where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')
select * from storeout where a.mater_no in (select mater_no from storein where in_no='141638' or in_no='141637'or in_no='141557' or in_no='141515' or in_no='141516')