|
Добавил скобки, команда вышла такая:
qbr.value('( (AS_ComVehicleLink.Node like ("var1")) || (RWPreliminaryRepair.AutoParkId like ("var2")) )');
Общий запрос:
SELECT FIRSTFAST * FROM RWPreliminaryRepair JOIN FIRSTFAST * FROM AS_ComVehicleLink WHERE RWPreliminaryRepair.VehicleId = AS_ComVehicleLink.VehicleId AND ((( (AS_ComVehicleLink.Node like ("var1")) || (RWPreliminaryRepair.AutoParkId like ("var2")) )))
Результат тот же.
|