Combining Tables

[sapnasarkar]

I have two table i have common keys As Cloud in both the table but they are not primary key. How can i combine them. Is there any other way to combine to combine them.

[Ankur Bawiskar]

@sapnasarkar 

what do you mean by combining tables?

Is this a business requirement?

Each table has it's own purpose to store data in it.

[sapnasarkar]

It's not BR. I have tables just want to combine all them together.

[Ankur Bawiskar]

@sapnasarkar 

Since it's not a business requirement what's your actual usecase for this?

what do you mean by combine all?

[Ayushi12]

@sapnasarkar  you can create Database view is basically functionality in ServiceNow where you can merge multiple table into one. For reference:https://www.servicenow.com/docs/bundle/utah-platform-administration/page/use/reporting/concept/c_Dat...
https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/use/reporting/concept/c_D...
https://www.servicenow.com/community/developer-forum/what-is-database-view-in-servicenow/m-p/2418370

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks!