Hi Guys,
While creating a view over 2 tables for generic extraction, in se11 when I create the view is the join a Union or Intersection?
I am giving a certain Product GUID as the join condition. Table B will only have a subset of all value of Product GUID as in Table A. What i need is to extract all GUID's from Table A and also get associated values from Table B.
Sample of to tables with GUID as Primary key...
Table A
GUID ...... Mtr_Typ
1............. ABC
2.............ABC
3.............BCD
4.............EFG
5.............XYZ
Table 2
GUID........ Reg_No.....CRValue
1...............12345.........50
3................2345..........75
I want the view to extract as
View
GUID.......MTR_Typ.....Reg_No........CRValue
1............. ABC............12345...........50
2.............ABC................#...............0
3.............BCD................2345..........75
4.............EFG................#...............0
5.............XYZ.................#...............0
So If I just create the view with respective join condition as Product_GUID and give all rest fields in both the tables will the output be as I want?
Or will the view only return GUID's which are existing in both tables .. i.e., an intersection?
I see the selection condition Tab in SE11. What do i give there to satisfy my condition?
Thanks
Kumar.