how to create the sub query in Ax

Finance and Operations/AX User Forum
1

i want to select the last row value of the table in jobs

i have tried like sql sub query but its not working

for that i used this code

while select * from table_nameobj where table_nameobj.Id==(select count(id) from table_nameobj)

{

}

but this is produced error could u please help me

2

If you want to select the last row, just sort the data in reverse order and select the first line.

3

This would help you:

custtable ct; //Your table

;

select firstonly ct order by recid desc;

if(ct)

{

info(ct.AccountNum);

}