This should be a relatively simple thing to do. Basically I have SQL Server 2008, and I have attached
NorthWind database to it. This is my query which works fine.
SELECT [Customers].[CompanyName], [Orders].[OrderID]
LEFT JOIN [Northwind].[dbo].[Orders]
ORDER BY Customers.CompanyName;
In the second SQL line, how can I go about being able to do
Is it possible? or is it not the right way to do it? I have 3 more databases attached to SQL Server by the way and
NorthWindis not the only one. I googled it but I am not quite sure what terms to google. I just want to shorten my queries. Thank you