TA貢獻(xiàn)1835條經(jīng)驗(yàn) 獲得超7個贊
數(shù)據(jù)
我這里叫a,b,c了，跟你表1，2，3是對應(yīng)的
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | create table a(uid int,name varchar(10)) insert into a values (1,'張一') insert into a values (2,'張二')
create table b (uid int,type1 varchar(1)) insert into b values (1,'a') insert into b values (1,'b') insert into b values (1,'c') insert into b values (2,'b') insert into b values (2,'c')
create table c(uid int,type2 varchar(1)) insert into c values (1,'a') insert into c values (2,'b') insert into c values (2,'c') |
運(yùn)行
1 2 3 4 5 | select t1.uid,t2.c1,t3.c2 from a t1 left join (select uid,count(*) c1 from b group by uid) t2 on t1.uid=t2.uid left join (select uid,count(*) c2 from c group by uid) t3 on t1.uid=t3.uid |
結(jié)果
舉報