SELECT TABLE1.A, TABLE1.B, TABLE2.E, TABLE3.H, TABLE4.K
FROM TABLE1 INNER JOIN
TABLE2 ON TABLE1.B=TABLE2.B INNER JOIN
TABLE3 ON TABLE1.C=TABLE3.C INNER JOIN
TABLE4 ON TABLE1.B=TABLE4.B
FROM TABLE1 INNER JOIN
TABLE2 ON TABLE1.B=TABLE2.B INNER JOIN
TABLE3 ON TABLE1.C=TABLE3.C INNER JOIN
TABLE4 ON TABLE1.B=TABLE4.B
inner join bef on abc.b = bef.b
inner join cgh on abc.c = cgh.c
inner join bki on abc.b = bki.b
inner join bef on abc.b = bef.b
inner join cgh on abc.c = cgh.c
inner join bki on abc.b = bki.b
T1,T2,T3,T4
where t1.b=t2.b
and t1.c=t3.c
and t1.b=t4.b