Data Source as sql statement for the PS query.

Hi all,

  Can we make a PS query same as below query.

ex: select * from (select *  from ps_asset);

Each time we when we create a new query we have to search for the records and select them for the data source. Here i am trying to select the values from the output of the subquery. I know we can create a sql view and select the values from the record, but i am trying to find the way to do it in the PSquery only with out creating a new sql view.

Please guide.

Regards,

Praneeth