Register now or log in to join your professional community.
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;