Использование условия if и запроса к базе данных

[Sada]

как то так

if (localsalestable.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)