1Değil SELECT t_menus.*, COALESCE((SELECT Ad FROM t_menu_lang WHERE LangAydi = 1 AND DataAydi = t_menus.Aydi), t_menus.Kod) AS dataAd, (SELECT Baslik FROM t_menu_lang WHERE LangAydi = 1 AND DataAydi = t_menus.Aydi) AS dataBaslik FROM t_menus WHERE t_menus.Aydi = '0'