SQL Outer Join multiple Views

[ilc]

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

[Funce]

Is it necessary to have them in separate tables? This seems like the exact trouble you'd run if they're separate.

 

You might want to look at `CASE` statements, and using `EXISTS`. If you really want to go down this route. I tried looking at these questions:

https://stackoverflow.com/questions/4076098/how-to-select-rows-with-no-matching-entry-in-another-table/36694478#36694478

https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select

[justsomeguy]

If everything is the same type you can just select a scalar value:

SELECT 'Vendor Contract' as `type`, item_code, desc, qty...