Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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?

user-image
Question added by Kjell Bjerke
Date Posted: 2016/12/12
Chinonso Emma-Ebere
by Chinonso Emma-Ebere , Internship , Al Tayer

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;

More Questions Like This