MYSQL EXİSTS ÖRNEK

select * from mesajlar
where

not exists /*not exists or exists */
(
select * from uyeler
where
mesajlar.gonderen = uyeler.id
)

Mehmet Mutlu