數(shù)據(jù)

我這里叫a,b,c了，跟你表1，2，3是對(duì)應(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é)果