If the sales and stocks database are in the same
server that is under 1 box/server
then you can join them
eg
from sales..tablename sales, stocks..tablename stocks
where sales.key=stocks.key
sales..tablename is a shortcut for sales.dbo.tablename
If the 2 databases are not under one box
you my consider doing it
Previous
Next
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