When I following this tutorial and I tried for part the left join is failed. I don't know why, please tell me to fix.
This code in controller:
public function actionGetSka($kodeSka)
{
$query = new Query;
$query->select(['ska.no_ska','ska.tgl_ska','ska.kode_anak_asuh','anak_asuh.kode_calon','calon.nama_calon','ska.kode_calon_keluarga_asuh','calon_keluarga_asuh.nama','calon_keluarga_asuh.jenis_kelamin','calon_keluarga_asuh.pekerjaan','calon_keluarga_asuh.alamat'])
->from('ska')
->join('LEFT JOIN', 'anak_asuh',
'anak_asuh'.'kode_anak_asuh' = 'ska'.'kode_anak_asuh')
->join('LEFT JOIN', 'calon_keluarga_asuh',
'calon_keluarga_asuh'.'kode_calon_keluarga_asuh' = 'ska'.'kode_calon_keluarga_asuh')
->join('LEFT JOIN', 'calon',
'calon'.'kode_calon' = 'anak_asuh'.'kode_calon')
->limit(2);
$command = $query->createCommand();
$data = $command->queryAll();
echo Json::encode($kodeSka);
}