Kod:
SELECT adisoyadi,secenek,profil, ceptelefonu, "ceptelefonu" As Telefon
FROM tbl_kisiler
where ((ceptelefonu) Is Not Null) AND ((secenek)="2" Or (secenek)="1")
union
SELECT adisoyadi,secenek,profil, ceptelefonuiki, "ceptelefonuiki" As Telefon
FROM tbl_kisiler
where ((ceptelefonuiki) Is Not Null) AND ((secenek)="2" Or (secenek)="1")
UNION SELECT adisoyadi,secenek,profil, ceptelesi, "ceptelesi" As Telefon
FROM tbl_kisiler
where ((ceptelesi) Is Not Null) AND ((secenek)="2" Or (secenek)="1")
ORDER BY adisoyadi;