need help with database view

[priyanka chodip]

Hi There,

i have a requirement to get cases with a,b,c groups that has an sla or not
so i created tables below

result looks like below

it is acutally getting SCTASK,Case and other as well.
but i need only Case table data.
please advice on it.

Thankyou

[Dr Atul G- LNG]

Ho @priyanka chodip 

It will be “as is” because it matches the sys_id. Try creating another DB view where the condition is manetib != sys_id, and then check if that works.

[OlaN]

Hi,

I believe that the Left join should be on the customer_case table (this is the base table and you want this to be the left table in your view).

We did a video on database view recently, and at about 22 min in we discuss the Left join option.

Have a look and see if it helps you.