Merging two tables one is task_survey and one more is survey_response

[Gangadhar540-]

I want to merge two table ( task_survey , survey_response ) for creation of report 

[Kirby R]

You can create a database view for this and create the report on that database view.

See detailed documentation here

Creating database views for reporting

[GlideFather]

Hi @Gangadhar540-,

do you have access to Database views?

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/use/reporting/task/c_Cr...

Create a new Database View record and in the related list define the tables:

And then a new Report will be created from this after it was Saved.

Also a good source of info: https://www.servicenow.com/community/developer-blog/what-is-servicenow-database-view-create-servicen...

Let me know how it goes

[Priti_S]

Hello @Gangadhar540- 
For this you can use Database views. This allows you to combine data from multiple tables into a single virtual table for reporting purposes.