How to merge two tables with union Operation

[prasad48]

Hi All,

How to merge two tables with union Operation

[davidpanson]

As I understand it you don't actually merge tables in Service Now. You use the data from your two tables to create an all new database view. The new database view will essentially be the outcome of merging your two (or more tables) while your original tables are left unchanged. Then you can just use your database view as you would a table.

http://wiki.servicenow.com/index.php?title=Database_Views

So go create a database view. Use the two tables you'd like to merge. You'll have to have some join statement to make them work correctly.

[prasad48]

Thanks David. To create Database view we might need atleast one common column in both tables.My requirement is SQL join Operation

Is this possible in ServiceNow?

[davidpanson]

You can add Left Join as a configuration when creating a database view. Outside of using a database view I don't believe there's another way but perhaps someone else will give you a different answer.