select a.* from
(select name from ouppatient where item='haoping' and amount>60) as a
left join (select name from ouppatient where item='chuzhen' and amount>60) as b
on a.name=b.name
where b.name is not null
select * from ouppatient where item in('haoping','chuzhen') and amount>60
select name from ouppatient where (item = 'haoping' or item = 'chuzhen') and amount>60
同一个人需要 存在 haoping 和chuzhen 同时大于60才输出名字 ,or 没同时,应该怎么写