Code: Select all
VIEW - Table1 - ID1
- ID2
- Value1
- Table2 - ID2
- Value2
Extract Requirement
ID1
ID2
Value1
Value2
do i need to say
Code: Select all
select ID1,
ID2,
Value1,
Value2
from VIEW
where Table1.ID2=Table2.ID2