Database view of catalog items where related SCTASK there's no SLA attached

[Carol2]

Hi All 

I created a database view using the task_sla and sc_task table. Both tables have the fields that I want to report on. I am stuck on joining the tables together to get the information I am looking for. Where the related SCTASK must give me the name of the catalog item and report on whether the task SLA field is populated or not. Please help i am new to creating database views 

[Ankur Bawiskar]

@Carol2 

are you saying you want to add 1 more condition to search for particular catalog item only?

if yes then do this

a) add 1 more table sc_req_item to join

sc_req_item order 300 prefix ritm where clause (ritm_sys_id = item_request_item)

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Carol2]

@Ankur Bawiskar 

The below doesn't work 

Using the table added I want to see a report that has the below information. So, meaning the SCTAK number in the TASK SLA table must match the SCTASK number in the Catalog task table and give me the information below

[Ankur Bawiskar]

@Carol2 

the where clause is wrong; it should be this

ritm.sys_id=item.request_item

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Carol2]

@Ankur Bawiskar 

Added the "where clause" shown below no records are displayed what am I missing?