21,893
社区成员




select a.*,b.grade,b.actor
from huiyuan a
jifen b on a.point>=b.min and a.point<=b.max and b.typeid=0
where a.username='真水无香';
union
select a.*,b.grade,b.actor
from huiyuan a
join jifen b on a.point>=b.min and a.point<=b.max and b.typeid=1
where a.username='真水无香';
union
select a.*,b.grade,b.actor
from huiyuan a
join jifen b on a.point>=b.min and a.point<=b.max and b.typeid=2
where a.username='真水无香';
union
select a.*,b.grade,b.actor
from huiyuan a
join jifen b on a.point>=b.min and a.point<=b.max and b.typeid=3
where a.username='真水无香';
union
select a.*,b.grade,b.actor
from huiyuan a
join jifen b on a.point>=b.min and a.point<=b.max and b.typeid=4
where a.username='真水无香';
select a.*,b.grade,b.actor,c.grade,c.actor,d.grade,d.actor,e.grade,e.actor,f.grade,f.actor,
from huiyuan a
left join jifen b on a.point>=b.min and a.point<=b.max and b.typeid=0
left join jifen c on a.point>=c.min and a.point<=c.max and c.typeid=1
left join jifen d on a.point>=d.min and a.point<=d.max and d.typeid=2
left join jifen e on a.point>=e.min and a.point<=e.max and e.typeid=3
left join jifen f on a.point>=f.min and a.point<=f.max and f.typeid=4
where a.username='真水无香';
select a.*,b.grade,b.actor,c.grade,c.actor,d.grade,d.actor,e.grade,e.actor,f.grade,f.actor,
from huiyuan a
left join jifen b on a.point>=b.min and a.point<=b.max and b.typeid='0'
left join jifen c on a.point>=c.min and a.point<=c.max and c.typeid='1'
left join jifen d on a.point>=d.min and a.point<=d.max and d.typeid='2'
left join jifen e on a.point>=e.min and a.point<=e.max and e.typeid='3'
left join jifen f on a.point>=f.min and a.point<=f.max and f.typeid='4'
where a.username='真水无香';
select a.*,b.grade,b.actor,c.grade,c.actor,d.grade,d.actor,e.grade,e.actor,f.grade,f.actor,
from huiyuan a
join jifen b on a.point>=b.min and a.point<=b.max and b.typeid='0'
join jifen c on a.point>=c.min and a.point<=c.max and c.typeid='1'
join jifen d on a.point>=d.min and a.point<=d.max and d.typeid='2'
join jifen e on a.point>=e.min and a.point<=e.max and e.typeid='3'
join jifen f on a.point>=f.min and a.point<=f.max and f.typeid='4'
where a.username='真水无香';
select h.*,j.`grade`,j.`actor` from `huiyuan` h
left join `jifen` j on h.`point`>=j.`min` and h.`point`<=j.`max`
where j.`typeid`='0' and h.`username`='真水无香';
SELECT huiyuan.*,jifen.grade,jifen.actor
FROM huiyuan
LEFT JOIN jifen
ON (huiyuan.point >= jifen.min AND huiyuan.point <= jifen.max)
WHERE huiyuan.username='真水无香';