Database view between rel_ci table and cmdb_sam_sw_install table

[R Aishwarya]

I'm trying to build database view between Business application table,rel_ci table,cmdb_sam_sw_install table.

I'm stuck in building where clause relation between rel_ci table , cmdb_sam_sw_install table.Kindly guide me how can i develop its relation.

[-O- · Accepted solution]

The last one should be rel_child= vs. rel_sys_id=.

[-O-]

Also I'm assuming you have defined/added the used fields to all those tables (Sys ID for cmdb_ci_business_app and cmdb_sam_sw_install and Child and Parent for cmdb_rel_ci).