переделать запрос sql

[hated8]

Наканецта!!!!!!!!
Ларчик просто открывался!

qbds = this.query().dataSourceTable(tablenum(RAssetTransferTable));
qbds.addDataSource(tablenum(RAssetLocation));
this.query().dataSourceTable(tablenum(RAssetLocation)).addRange(fieldNum(RAssetLocation, recid)).value('((RAssetTransferTable.NewLocation==Location) || (RAssetTransferTable.OldLocation==Location))');
this.query().dataSourceTable(tablenum(RAssetLocation)).addRange(fieldNum(RAssetLocation, userGroupId)).value(
(select groupId from UserGroupList
where UserGroupList.UserId == currentUserId).groupId
);

Спасиб огромное всем за помощь!!!