SQL查询

 

declare @TOrder table(torderID int primary key)
 insert into @TOrder(torderID)
 select distinct id
 from vw_OrderLastStatus ost where ost.status = @status

select 列名...
from 主表
join @TOrder tor on tor.torderID=m.id