Good Afternoon Santosh.
To be able to 'select from a view' in an SC/Admin/Report Builder/Data Object query, check the below:
1. Create a view in the mssql (mdb) database:
E.G.:
CREATE view [dbo].[z_order_information] as
select
a.request_id,a.name as request_name,
a.status as request_status,
a.created_date,a.modified_date,a.completion_date,a.domain,
a2.account_id,a2.name as account_name,
a.req_by_user_id,
a3.first_name,a3.last_name,
a.req_for_user_id,
from usm_request a
join usm_account a2 on a2.account_id=a.req_for_account_id
join ca_contact a3 on a3.userid=a.req_by_user_id
2. Create a new Data Object in the SC-UI with the query:
SELECT * FROM Z_order_information
3. Save and Test for the above shold then show the result.
Please check the above. Thanks and kind regards, Louis.