Something like this perphaps:

SELECT [a].[pi_fname], [b].[pi_sname] FROM [dev_hrpro].[dbo].[pi] a, [prod_hrpro].[dbo].[pi] b

Jon

>Hello,
>
>How can I make a query in SQL server that involves tables from different databases? I tried MyDB!MyTable, but that does not work.