SELECT * FROM maclar INNER JOIN klan WHERE maclar.mac_Takim1=klan.klan_id or maclar.mac_Takim2=klan.klan_id