“子查询返回超过1行”错误的解决方案

I have one query that returns multiple rows, and another query in which I want to set criteria to be either one of values from those multiple rows , so basicly I want the subquery to look something like this:I have one query that returns multiple rows, an