Skip to Content
0
Former Member
Jun 24, 2009 at 05:56 PM

Creating a view for extraction over 2 tables

749 Views

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.