Help rewriting query

Could anyone help with rewriting queries below that are equivalent to avoid self-join or subquery in the second query so the materialized view fast refresh would be possible ?

SELECT *
FROM t1 tab1, t1 tab2, t3 tab3
WHERE tab3.c31 = tab1.c11
and tab3.c32 = tab2.c12;

SELECT *
  FROM (t3 inner JOIN t1 ON t3.c31 = t1.c11) inner JOIN t1 tab2 ON t3.c32 = tab2.c12;

If it's not possible, any solution other than duplicate tables ? Received on Tue Nov 15 2005 - 06:12:30 CST