How to write a proper select on 3 tables (t1, t2 and t3). I need an outer join (+) between all 3, and I need to check for a constant in t2?

using one tables as a reference, it should have one column that is similar to another column to be able to give you the best result.

for Example

Select t1.a, t2.b, t3.c

from t1, t2, t3

where t1.z=t2.z

and t1.c=t3.c;