Select t1.a, t2.d, t2.e
from t2, t2
where t2.k = t1.b