creating database view connecting task table and sn_hr_core_case_operations table

[poornima batchu]

hi all, 

I'm trying to create DB view containing both task table coloumns and hr tech (sn_hr_core_case_operations) table. I need pull all tickets dump. what is where clause I need to apply here ?

please give solutions

[Jugmaz]

well, you have one there already as sn_hr_core_case_operations table is extended from TASK (after extended from sn_hr_core_case).

So, even if you create this view, you would not get any more information!?

What is your requirement here?

[poornima batchu]

I'm trying to show coloumns from both the tables in a single report. Is there any other way I can get this.

[Jugmaz]

but you have all the columns already there  - if you look the table straight in the sys_db_object you may see that all the fields are there:
https://[YOURINSTANCeNAME].service-now.com/nav_to.do?uri=sys_db_object.do?sys_id=36aff81ddbb1a41023a...

[Ankur Bawiskar]

Hi,

sn_hr_core_case_operations extends HR Case and HR Case extends Task

What's your actual requirement?

Why to join those 2 tables?

Example: it makes no sense joining incident table with task since incident is already extending task table