yii子查询

yii子查询写法

\(subQuery </span><span>= new Query</span><span>()</span><span>;</span></p><p><span>\)subQuery-&gt;from(‘test’);
\(query = new Query();</span></p><p><span>\)query-&gt;from(‘info as i’);
\(query</span><span>-&gt;</span><span>innnerJoin</span><span>([</span><span>'s' </span><span>=&gt; </span><span>\)subQuery], ’s.infoId=i.id’);