X++:
if (salestable.salesid == (select salesid from salestable
where salestable.SalesStatus == salesstatus::completeleft
join wmspickingroute
where wmspickingroute.transrefid == salestable.salesid &&
(wmspickingroute.expeditionstatus == wmsexpeditionstatus::started ||
wmspickingroute.expeditionstatus == wmsexpeditionstatus::activated)).SalesId)
может так?