Ndtyjky

I am using SQL query but query resulted 12 lines, needs to be 3 lines; I can't figure it out.

Not working query:

SELECT g.*

    ,c.TxtFobFiyati

    ,C.TxtTalepETeslimTarihi

    ,c.TslParaBirimi

    ,c.TxtFiyat

    ,C.TslDepoKodu

    ,c.TslOlcuBirimi AS 'Olcu'

    ,j.TxtAmbalajDara

    ,j.TxtPaletDara

    ,g.TxtAdet AS 'ambalajAdet'

    ,g.TxtPaletSayisi AS 'paletSayisi'

    ,j.TxtAmbalajAdi

    ,J.TxtAmbalajNetKG

    ,j.TxtBoxGrossWeight

    ,C.TxtAciklama AS 'KalemAciklama'

    ,G.TxtAciklama AS 'KalemAciklama2'

    ,g.TxtPaletUstu AS 'PaletUstu'

    ,g.TxtPaletSayisi AS 'PaletSayisi'

    ,c.TxtUrunAdiEng AS 'UrunAdi_Ingilizce'

    ,C.TxtFobFiyati AS 'FobFiyati'

    ,j.TslPaletTipi AS 'PaletTipi'

    ,j.TxtPaletDara AS 'PaletDara'

FROM E_KT_SAS_Form A

LEFT JOIN E_KT_SAS_Form_DtyUrunler2 B

    ON A.ID = B.FORMID

LEFT JOIN E_KT_SAS_FrmSipUrunEkle C

    ON B.DOCUMENTID = C.ID

LEFT JOIN E_KT_SAS_Form_DtyTeyitEdilen2 D

    ON A.ID = D.FORMID

LEFT JOIN E_KT_SAS_FrmUretimTarihiEkle E

    ON D.DOCUMENTID = E.ID

        AND E.TslUrun = C.TslUrunKodu

LEFT JOIN E_KT_SAS_Form_DtySevkiyatlar F

    ON A.ID = F.FORMID

LEFT JOIN E_KT_SAS_FrmSevkiyatEkle G

    ON F.DOCUMENTID = G.ID

LEFT JOIN E_KT_SAS_FrmSipUrunEkle_DtyAmbalajlama H

    ON C.ID = H.FORMID

LEFT JOIN E_KT_SAS_FrmUrunAmbalajlama J

    ON H.DOCUMENTID = J.ID

WHERE E.TslOnay_TEXT = 'Evet'

    AND C.TslUrunKodu = G.TslUrun

    AND A.ID = 11682

Not working result

Correct result table

Step1) Start count with the driver table i.e. the one you have alias as 'A'. Check the count if you get 3. Continue.
Repeat step 1 with each new join and see where your count blows up to 12. That is your troubling join. Comment it out if possible and continue with joins. If you cannot do successive joins then find best solution to bring count back down to 3.

If your sure of your where clause great; else start without it too. If count is more than 3. Pop it back in.

  select count(1) 

    FROM E_KT_SAS_Form A

    LEFT JOIN E_KT_SAS_Form_DtyUrunler2 B ON A.ID = B.FORMID

    LEFT JOIN E_KT_SAS_FrmSipUrunEkle C  ON B.DOCUMENTID = C.ID

    LEFT JOIN E_KT_SAS_Form_DtyTeyitEdilen2 D ON A.ID = D.FORMID

    LEFT JOIN E_KT_SAS_FrmUretimTarihiEkle E ON D.DOCUMENTID = E.ID

            AND E.TslUrun = C.TslUrunKodu 

    LEFT JOIN E_KT_SAS_Form_DtySevkiyatlar F ON A.ID = F.FORMID

    LEFT JOIN E_KT_SAS_FrmSevkiyatEkle G ON F.DOCUMENTID = G.ID

    LEFT JOIN E_KT_SAS_FrmSipUrunEkle_DtyAmbalajlama H ON C.ID = H.FORMID

    LEFT JOIN E_KT_SAS_FrmUrunAmbalajlama J ON H.DOCUMENTID = J.ID

    WHERE E.TslOnay_TEXT = 'Evet' AND C.TslUrunKodu = G.TslUrun AND A.ID = 11682