How to create database views for reports generating

[Gopal14]

Hi Team,

I need to generate one report using two different table fields.

sc_req_item table(5 fields) and task_sla table(I have 2 fields)

For this I have created a database view, Below is my database view

Now I am trying to create a report, In source type I have selected table and selected my table(u_sla_7)

When I click on next it is showing No records to display,

Any suggestions why data is not showing, or Do I need to change anything in database views

@Ankur Bawiskar 

[suvro]

where clause should be ts.task=sri.sys_id

[younes_sebti]

I second Suvro's replies but database views doesn't like comma.

It would rather be ts_task=sri_sys_id