Create Database view for 3 tables: cmdb_ci, cmdb_model, cmdb_model_life_cycle

[shubhi211]

Hi team,

I need to link 3 tables: cmdb_ci, cmdb_model, cmdb_model_life_cycle. Let me know what should be the where clause:

[Uncle Rob · Accepted solution]

Greatly depends on what you're hoping to achieve.
What is the purpose the database view is fulfilling, written as a statement vs a technical need?

[Uncle Rob · Accepted solution]

Greatly depends on what you're hoping to achieve.
What is the purpose the database view is fulfilling, written as a statement vs a technical need?

[shubhi211 · Accepted solution]

I need to link all three table and then need to create a report, so that I can fetch values like: Phase end date, Model categories, Description