I want to create a custom field within one of the views using another view - Between CUSTOMER_ORDER_LINE & SHOP_ORD_PUB.

And I want a column(custom field) on which I need to join these two views. Help me figure it out.

Here, I want to create a custom field ‘Available Qty To Peg’ on view-CUSTOMER_ORDER_LINE from view-SHOP_ORD_PUB