改成这样试试:
SELECT id,name,person from t_manage where person in (select person
FROM t_manage WHERE user='varuser') 前提PERSON字段为字符型
SELECT id,name,person from t_manage where person in (select person
FROM t_manage WHERE user='varuser') 前提PERSON字段为字符型
declare @varuser varchar(10)(或其他类型)
SELECT id,name,person from t_manage where person = (select person
FROM t_manage WHERE user=@varuser)
SELECT id,name,person from t_manage where person = (select name
FROM t_manage WHERE user='varuser')
你的
select person
FROM t_manage WHERE user='varuser'取出来的是李四。。不是张三。。应该用取得person=name张三