HI all,
I have a query that when i change the field in the select clause, also change the result set, try to explain better.
i write this query:
select
t1.aa,
t2.bb,
t3.cc,
t2.bb
from table1 t1,table2 t2,table3 t3
where t1.aaa=t2.bbb
and t2.fff=t3.www
the result set of the previus query is 2 rows
while if i change it a little bit as follow is:
select
t1.aa,
--t2.bb,
t3.cc,
t2.bb
from table1 t1,table2 t2,table3 t3
where t1.aaa=t2.bbb
and t2.fff=t3.www
the result set contain only one row; I'm asking while this is possible.
Of course the really case has more than 3 table and there are also some outer join using the ( + ) operator.
This is a very strange thing changing the field in the select and change the result set