select username from [shop_action] where username='('select username from [shop_user] where tuijianren='hx001@163.com')'
有错没有
參考答案:有错,后面的select 少了个别名
select username from [shop_action] where username=(select username from [shop_user] where tuijianren='hx001@163.com') t