Kod:
select alan1, alan2 from tablo1
union all
select alan1, alan2 from tablo2
union all
select alan1, alan2 from tablo3
Kod:
SELECT Ogrt_1, AdiSoyadi FROM Ogrenciler WHERE AdiSoyadi=[Formlar]![Form1]![Liste2]
UNION
SELECT Ogrt_2, AdiSoyadi FROM Ogrenciler WHERE AdiSoyadi=[Formlar]![Form1]![Liste2]
UNION
SELECT Ogrt_3, AdiSoyadi FROM Ogrenciler WHERE AdiSoyadi=[Formlar]![Form1]![Liste2]