[RESOLVED] Cross Database Queries

[FishGuy]

Hi,

SELECT Orders.OrderID, Orders.DealerID, Dealers.Dealer, Orders.OrderDate, Orders.ShipDate, Orders.Cancelled, Dealers.DealerType
FROM Dealers INNER JOIN Orders ON Dealers.ID = companysql.AcornInternational.Orders.NewDealerID
WHERE (((Orders.ShipDate)>GetDate()) AND ((Orders.Cancelled)=0) AND ((Dealers.DealerType)="Export"));

I have the following sp Select Im trying to set up. The problem is the sp will Reside on the same server (company sql) but in a different database from one of the tables required (Orders).

How do I cross Query the table Orders from AcornInternational database?