Urgent :- Need help in database view . Need to join case table table with survey response table.

[priyankar umesh]

Need to join case table table with survey response table(asmt_metric_result) but i want to show data of only two metric type . 
please help me to define where clause 

[Brad Bowman]

I have used a where clause like this joining the asmt_metric_result table to the asmt_assessment_instance table:

aai_sys_id = amr_instance && aai_metric_type = '4c309f1c3b131300bc1e832b44efc492'

Since you have two sys_ids / metric types, there could be a limitation on the where clause capability, so if the above works for one, something like

aai_sys_id = amr_instance && (aai_metric_type = '4c309f1c3b131300bc1e832b44efc492' || aai_metric_type = '12345678...')

 may not work for two.  In this case, you can leave both out of the where clause and create a before Query Business Rule, using the Database View as the table to only show the two metric types.  Give this a shot and post the script if you get stuck.