34,594
社区成员
发帖
与我相关
我的任务
分享
Select top 1
Inv_id=A.Inv_id
From Inv A
Inner Join Loc loc on A.Loc_id=loc.Loc_id
Where loc.Wh_id=-1581427986821640114 And A.Inv_status='-10'
Select -- top 1
Inv_id=A.Inv_id
From Inv A
Inner Join Loc loc on A.Loc_id=loc.Loc_id
Where loc.Wh_id=-1581427986821640114 And A.Inv_status='-10'