Use of symbol @ in select statement.

Finance and Operations/AX Developer Forum
1

Hi,
while select @Group, Owner, Access from secPermissionTbl where (secPermissionTbl.SECURABLEOBJECT == securableObjectRecId )
join recId from permissionOwnerTbl where (secPermissionTbl.OWNER == permissionOwnerTbl.RECID)

2

Group is a field in that table. We also have group by in AX with same name.
It cannot be used directly in select statement. (@) is used , so that it will be considered as field rather than the function in AX.

3

I have separated it from original thread and created a new thread. (so that it will help other with same question).

4

Hi,
Thanks a lot kranthi…