Hi all,
I want to do something like this
select f1,f2,f3
from
(select c1,c2,c3
from tab2 )
But it does not work
I´ve done this way
Select f1,f2,f3 from tab1 where EXISTS (select f1,f2,f3 from tab1 )
and it works, but when i cross diferent tables are the results realible ?
What i really want to do is a query where the first 2 fields work as key from the subquery ...
Thanks in advance.
R
I want to do something like this
select f1,f2,f3
from
(select c1,c2,c3
from tab2 )
But it does not work
I´ve done this way
Select f1,f2,f3 from tab1 where EXISTS (select f1,f2,f3 from tab1 )
and it works, but when i cross diferent tables are the results realible ?
What i really want to do is a query where the first 2 fields work as key from the subquery ...
Thanks in advance.
R