Global Find
The Global Find dialog builds UNIONed SELECT statements on the fields in you tables. Use the 'Scope' tab you search identical tables in other database that are also UNIONed into your query.
With this feature, it is very easy to build up very long, slow queries quickly. Be cautious about how the resulting query might put a strain on your server resources.