QUERY to get the IT Resource and Application Instance

QUERY to get the IT Resource and Application Instance

SELECT

    app_instance_name,

    app_instance_display_name,

    app_instance_description,

    svr.svr_name,

    app_instance_dataset

FROM

    app_instance,

    svr

WHERE

        app_instance_name LIKE '%Instance Name%'

    AND

        svr.svr_key = app_instance.itresource_key