C:\DibalCom\ True True False select Twr_Nazwa Nazwa,Twr_EAN PLU , ISNULL(Cena1.TwC_Wartosc,0) Cena1, ISNULL(Cena2.TwC_Wartosc,0) Cena2, ISNULL(Cena3.TwC_Wartosc,0) Cena3, CAST (CAST ( ISNULL(TwA_WartoscTxt,0) as float ) as int) KlawiszSkrot from CDN.Towary LEFT OUTER JOIN CDN.TwrCeny Cena1 ON Cena1.TwC_TwrId = Twr_TwrId and Cena1.TwC_TwCNumer = 5 LEFT OUTER JOIN CDN.TwrCeny Cena2 ON Cena2.TwC_TwrId = Twr_TwrId and Cena2.TwC_TwCNumer = 2 LEFT OUTER JOIN CDN.TwrCeny Cena3 ON Cena3.TwC_TwrId = Twr_TwrId and Cena3.TwC_TwCNumer = 3 LEFT OUTER JOIN CDN.TwrAtrybuty On TwA_TwrId = Twr_TwrId LEFT OUTER JOIN CDN.DefAtrybuty ON TwA_DeAId = DeA_DeAId and DeA_Kod = 'KLAWISZ_SKROT' where LEN(Twr_EAN ) =4 False