Hi merictokatlio...,
Your query is correct.
Since there are multiple images available for ProjeID and KatID it is returning multiple records.
If you want to only one record then use TOP or Limit function.
TOP
SELECT TOP 1
ProjeDetay.ProjeID,
ProjeDetay.KatID,
ProjeDetay.ProjeAdi,
ProjeDetay.Aciklama,
ProjeDetay.KapakFoto,
ProjeDetay.BaslangicTarihi,
ProjeDetay.BitisTarihi,
ProjeDetay.ArkaPlanGorsel,
ProjeDetay.SeoBaslik,
ProjeDetay.SeoKelime,
ProjeDetay.SeoAciklama,
ProjeFotolar.Foto,
ProjeKat.KatID,
ProjeKat.KatAdi
FROM
dbo.ProjeDetay
INNER JOIN
dbo.ProjeFotolar
ON
ProjeDetay.ProjeID = ProjeFotolar.ProjeID
INNER JOIN
dbo.ProjeKat
ON
ProjeDetay.KatID = ProjeKat.KatID
ORDER BY
ProjeDetay.ProjeAdi ASC
LIMIT
SELECT
ProjeDetay.ProjeID,
ProjeDetay.KatID,
ProjeDetay.ProjeAdi,
ProjeDetay.Aciklama,
ProjeDetay.KapakFoto,
ProjeDetay.BaslangicTarihi,
ProjeDetay.BitisTarihi,
ProjeDetay.ArkaPlanGorsel,
ProjeDetay.SeoBaslik,
ProjeDetay.SeoKelime,
ProjeDetay.SeoAciklama,
ProjeFotolar.Foto,
ProjeKat.KatID,
ProjeKat.KatAdi
FROM
dbo.ProjeDetay
INNER JOIN
dbo.ProjeFotolar
ON
ProjeDetay.ProjeID = ProjeFotolar.ProjeID
INNER JOIN
dbo.ProjeKat
ON
ProjeDetay.KatID = ProjeKat.KatID
ORDER BY
ProjeDetay.ProjeAdi ASC
LIMIT 1