This works thanks!

Since both databases are identical is there any way I can filter on a field and it search both databases? Or do I have to do it in separate select queries?

I'd like to use this in SSRS but only have one filter to use for the report.