sql server - How to see the SQL expression of an X++ select statement? -


i have below statement in job in ax:

select recid pjitable      join pid, type, prid sjtable     pjitable.prid == sjtable.prid &&          (sjtable.type == pjtype::timematerial || sjtable.type == pjtype::fixedprice); 

i have use in sql server. how can convert select statement sql , use in sql server management studio?

for debugging purposes can change select query , use getsqlstatement method on table:

select generateonly forceliterals recid pjitable      join pid, type, prid sjtable      pjitable.prid == sjtable.prid  &&          (sjtable.type == pjtype::timematerial || sjtable.type == pjtype::fixedprice);     info(pjitable.getsqlstatement()); 

this show sql statement without executing statement.