X++:
if (localsalestable.salesid == (select salesid from salestable
where salestable.SalesStatus == salesstatus::completeleft
join wmspickingroute
where wmspickingroute.transrefid == localsalestable.salesid &&
(wmspickingroute.expeditionstatus == wmsexpeditionstatus::started ||
wmspickingroute.expeditionstatus == wmsexpeditionstatus::activated)).SalesId)
как то так наверно, сразу не сообразил