select y.yazarID ,kymax.yaziID ,kymax.yazibaslik from yazarlar y
inner join koseyazilari ky on ky.yazarID=y.yazarId
inner join koseyazilari kymax on kymax.yazarID=y.yazarId
group by y.yazarID,kymax.yaziID,kymax.yazibaslik
having kymax.yaziID=max(ky.yaziID)
|