Re: SQL not working in 10g Release 2

> select column1,.....,columnx from t,(select col1 from t2 where
> t2.xyz='1234') t2

I think you should use another alias to this query ..

select column1,.....,columnx from t,(select col1 from t2 where t2.xyz='1234') t3
where t.column1 = t3.col1

-- 
Regards
Morff
----------------------
AQQ 141151
Powered by Opera/M2