/**
燕十八 公益PHP培训
课堂地址:YY频道88354001
学习社区:www.zixue.it
**/
create table m(
mid int primary key,
hid int,
gid int,
mresult varchar(20),
mtime date
)engine myisam charset utf8;
insert into m
values
(1,1,2,'2:0','2006-05-21'),
(2,2,3,'1:2','2006-06-21'),
5.4:
(3,3,1,'2:5','2006-06-25'),
(4,2,1,'3:2','2006-07-21');
create table t(
tid int,
tname varchar(20)
)engine myisam charset utf8;
insert into t
values
(1,'国安'),
(2,'申花'),
(3,'公益联队');
select t1.tname,mtime,t2.tname
from
m left join t as t1 on hid = t1.tid
left join t as t2 on gid = t2.tid
where mtime between '2006-06-00' and '2007-00-00';
6.2:
create table a(
id char(1),
num int
)engine myisam charset utf8;
insert into a
values
('a',5),
('b',10),
('c',15),
('d',10);
create table b(
id char(1),
num int
)engine myisam charset utf8;
insert into b
values
('b',5),
('c',15),
('d',20),
('e',99);
select id,sum(num) from (select * from a union all
select * from b) as c group by id;