Jump to content

ilc

Members
  • Posts

    1
  • Joined

  • Last visited

ilc's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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
×
×
  • Create New...