Database View

Jason Rooney
Tera Contributor

Team

I need help again...

Need to create a database view with the following tables.  Can you provide me with where clauses? databaseview.png

 

cmdb_rel_ci

cmdb_ci_business_app

cmdb_ci_business_capability

 

Thanks again

Hope to see you at Knowledge 25

1 ACCEPTED SOLUTION

Chaitanya ILCR
Kilo Patron

Hi @Jason Rooney ,

ChaitanyaILCR_0-1741023260675.png

try this

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

1 REPLY 1

Chaitanya ILCR
Kilo Patron

Hi @Jason Rooney ,

ChaitanyaILCR_0-1741023260675.png

try this

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya