这样试试 select shoujihao from jilu where exists (select 1 from huiyuan where huiyuanming=jilu.huiyuanming and huiyuantoken='token')
select shoujihao from jilu where huiyuanming = (select huiyuanming from huiyuan where huiyuantoken = input) 可以试一下，如有错误欢迎指出，其中的input是首先传入要查询的变量
