General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only