View
Posted: Thu Jun 22, 2006 11:05 am
Can a view have more than one table in it. If at all yes. then how do i read from different tables. Like say I have
do i need to say
Am I in the right direction??
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