title: How to see the SQL expression of an X++ select statement?
body: <p>I have below statement in a job in AX:</p>
  
  <pre><code>select RecId from pjiTable 
      join pID, Type, PrId from sjTable
      where pjiTable.Prid == sjTable.PrId &amp;&amp;
           (sjTable.Type == PjType::TimeMaterial || sjTable.Type == PjType::FixedPrice);
  </code></pre>
  
  <p>I have to use it in SQL Server. How can I convert this <code>select</code> statement into SQL and use it in SQL Server Management Studio? </p>