您可以将其包装在子查询中，如下所示:

You can wrap it in a sub-query like this:

SELECT * 
FROM (
        select (select A from B where ... ) as C from D
     ) subq
WHERE 
    C like ' ... '