如果值可以转换为INT类型，如何强制SQL只计算连接?

I've got a query that uses several subqueries. It's about 100 lines, so I'll leave it out. The issue is that I have several rows returned as part of one subquery that need to be joined to an integer value from the main query. Like so: I've got a query that uses several subqueries.