->alias('AS as')
->leftJoin(['tb_semantics'=>'s'],'as.skill_id = s.skill_id');
$field = 'distinct dul.id,dul.name,dul.code as code';
$lexiconData1 = $db
->alias('AS as')
->field($field)
->leftJoin(['tb_user_lexicon'=>'ul'],'ul.id = s.lexicon_id')
->where($where)
->select();
$names = $db
->field('distinct ds.name')
->select();
这样的sql 为什么$names 会引用$lexiconData1 的 distinct dul.id,dul.name,dul.code as code 和左联->leftJoin(['tb_user_lexicon'=>'ul'],'ul.id = s.lexicon_id')
最佳答案