Views & joining same table twice?
I am running into this problem and I am stuck.
I need to join two views into one view,
or include one view into another containing base tables,
or join the same table twice using, maybe, and alias.
I have to create a view which joins vendor number and name with manufacturer number and name. All this through views and no coding.
There already exists a working view containing the vendor info and manufacturer number.
Using the manufacturer number (MFRNR) from the above, I want to fetch the name from LFA1-NAME1.
The problem is that LFA1-NAME1 is already used in the above view as the vendor name with the join condition EINA and LFA1.
The end result should display: vendor_# vendor_name manufacturer_# manufacturer_name.