How yii2 uses leftjoin to generate on. And query statement

$sql = Wrong::find()->where([
            "t.fdUserID" => 4,
            "t.fdStatus" => 0
        ])->alias("t")->leftJoin(Exercise::tableName()." exercise","exercise.id=t.fdExerciseID",["exercise.fdStatus"=>1]);
print_r($sql->createCommand()->getRawSql());

printed sql statement is 

SELECT `t`.* FROM `tbWrong` `t` LEFT JOIN `tbExercise` `exercise` ON exercise.id=t.fdExerciseID WHERE (`t`.`fdUserID`=4) AND (`t`.`fdStatus`=0)

I would like to ask why the exercise.fdStatus=1 condition has not been generated, and how to generate the desired sql statement 

SELECT `t`.* FROM `tbWrong` `t` LEFT JOIN `tbExercise` `exercise` ON (exercise.id=t.fdExerciseID AND exercise.fdStatus=1) WHERE (`t`.`fdUserID`=4) AND (`t`.`fdStatus`=0)
Yii2
Mar.06,2021 
Wrong::find()
    ->where([
        't.fdUserID' => 4,
        't.fdStatus' => 0
    ])
    ->alias('t')
    ->leftJoin(
        Exercise::tableName().' exercise',
        'exercise.id=t.fdExerciseID and exercise.fdStatus=1'
    );

Previous: Require ('webpack'), cmd error webpack is not defined) when using webpack

Next: What's wrong with pymysql import?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu