ID_SET(columnName, 'sizeThresholdInBytes=8388608;expectedInsertions=5000000;fpp=0.03' )
IN_ID_SET(columnName, base64EncodedIdSet)
IN_SUBQUERY(columnName, subQuery)
IN_PARTITIONED_SUBQUERY(columnName, subQuery)
IN_SUBQUERY
and IN__PARTITIONED__SUBQUERY
can be run on any table - they aren't restricted to the table used in the parent query.