select * from a,b where a.id=b.b_id and a.no='001' and b.startdate is not null;
select * from a,c where a.id=c.c_id and c.class='user' and c.groupd ='group1';
select * from
(
select * from a,b
where a.id=b.b_id
and a.no='001'
and b.startdate is not null
)a,
(
select * from a,c
where a.id=c.c_id
and c.class='user'
and c.groupd ='group1'
)b
where a.id=b.c_id;
select * from d where d.name='xiao' or d.name='lin'
select * from
(
select *
from
(
select * from a,b
where a.id=b.b_id
and a.no='001'
and b.startdate is not null
)t,
(
select c.c_id,c.class,c.groupd from a,c
where a.id=c.c_id
and c.class='user'
and c.groupd ='group1'
)w
where t.id=w.c_id
) f
left join
(
select * from d
where d.name='xiao'
or d.name='lin'
) e on f.b_id=e.d_id;