Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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;
