语法

join(mixedjoin[,mixed$condition=null[,string$type='INNER']])

示例

别名

Db::table('think_artist')->alias('a')->join('think_workw','a.id=w.artist_id')->join('think_cardc','a.card_id=c.id')->select();

Db::table('think_artist')->alias('a')->join('__WORK__w','a.id=w.artist_id')->join('__CARD__c','a.card_id=c.id')->select();

$join=[['think_workw','a.id=w.artist_id'],['think_cardc','a.card_id=c.id'],];Db::table('think_user')->alias('a')->join($join)->select();

全称

Db::table('think_user')->join('__WORK__','__ARTIST__.id=__WORK__.artist_id')->select();

right方式

Db::table('think_user')->alias('a')->join('wordw','a.id=w.artist_id','RIGHT')->select();

表名是子查询

$subsql=Db::table('think_work')->where(['status'=>1])->field('artist_id,count(id)count')->group('artist_id')->buildSql();Db::table('think_user')->alias('a')->join([$subsql=>'w'],'a.artist_id=w.artist_id')->select();