I am trying to join data from two views. The first has a column "Type". I need to insert data from the second but identify it as a certain "Type". I have performed an Outer Join. How can I insert type for the data in the second view.
The "Type" field in the first view is identifying whether the inventory is on hand or inbound. I want to identify the data from the second view as Type- Vendor Contract.
My columns are:
1st view (Inventory on Hand/Inbound) - Item Code, Desc, Qty, Type
2nd view (Inventory Contracted with Vendors)- U_Item Code, Desc, Qty
SQL Outer Join multiple Views
in SQL
Posted
I am trying to join data from two views. The first has a column "Type". I need to insert data from the second but identify it as a certain "Type". I have performed an Outer Join. How can I insert type for the data in the second view.
The "Type" field in the first view is identifying whether the inventory is on hand or inbound. I want to identify the data from the second view as Type- Vendor Contract.
My columns are:
1st view (Inventory on Hand/Inbound) - Item Code, Desc, Qty, Type
2nd view (Inventory Contracted with Vendors)- U_Item Code, Desc, Qty