Subjquery outside of Join

Yii 2.0 General Discussions
1

Hi guys, code downstairs will perfom query like this




SELECT anrede FROM `l_anrede` INNER JOIN `person` ON `l_anrede`.id = `person`.id_anrede

But I need a query like this:




  SELECT anrede FROM `l_anrede` INNER JOIN `person` ON `l_anrede`.id=`person`.id_anrede  WHERE

`person`.id IN(SELECT id_person FROM `bewerber` WHERE  `person`.id=`bewerber`.id);

Any ideas how to round out this code:




$query = LAnrede::find();

/*

$subQuery = Bewerber::find()->select(['id_person'])

                ->from('bewerber')->where('person.id= bewerber.id');*/


$query->select('anrede')->from('l_anrede')->innerJoin('Person', 'l_anrede.id = person.id_anrede');

var_dump($query->one());