Database view that displayes all catalog items with and without the linked service offering

[TomiC]

Hi,

How can I create a database view that displays all catalog items with and without the linked service offering?

Thanks & Regards

[Yousaf]

HI @TomiC 

I don't think there is a relation between these two tables. So we cannot create database view to acheive this
I could only find one table where catalog items are being referenced but still that wont help that only shows linked subscriptions
Table : sc_cat_item_subscribe_mtom