SQL搜索过滤id列表

I'm curious if there is a crafty way to accomplish the following through SQL only. I have a list of id's from one database and I want to filter this list against another database/table. The requirements are: I'm curious if there is a crafty way to accompl