1Değil SELECT t_firmas.*, t_naces.NaceKodu as NaceAd FROM t_firmas LEFT JOIN t_naces ON t_naces.Aydi=t_firmas.NaceAydi WHERE t_firmas.Aydi = 14