ORACLE:
SELECT
*
FROM
( SELECT '我的' a FROM dual UNION ALL
SELECT '你的' a FROM dual UNION ALL
SELECT '他的' a FROM dual )
WHERE
a = ANY (
SELECT
*
FROM
( SELECT '我们的' b FROM dual UNION ALL
SELECT '你的' b FROM dual UNION ALL
SELECT '他们的' b FROM dual ))
MySQL:
SELECT
*
FROM
( SELECT '我的' a UNION ALL
SELECT '你的' a UNION ALL
SELECT '他的' a ) t
WHERE
a = some (
SELECT
*
FROM
( SELECT '我们的' b UNION ALL
SELECT '你的' b UNION ALL
SELECT '他们的' b ) t2 )
ANY ->some 也可以