I have two tables: ‘section’ and ‘section_lang’.
The table ‘section_lang’ has a column with the value ‘Nice Section’.
This is my query:
$sections = self::find()->select(['section.id', 'section_lang.section_name'])->innerJoin('section_lang', 'section_lang.section_id = section.id')->where('section_lang.language_id = 1)->orderBy('section_lang.section_name')->all();
The ‘section_name’ result returned is: ‘NicNBSection’.
What gives?