Writing Inline Queries using PS Query Tool
To achive this we can use SQL objectsappdesigner create SQL object with in line select statement
use this SQL as exprestion in PSQuery
click on Add Expresstion
In Expresstion test place give SQL(Name of SQL Object) like ( %SQL(V_TEST))
click on save and then click on use it as field
This does not work in PS 9.1 Ptools 8.51 as it does not allow FROM keyword in expression.DO u know any other way to use inline sub queries as a select column in PS query.
ReplyDelete