Hello Eric, thanks for the reply. I think OPENROWSET is what I am looking for, but I can't seem to get it to work. I keep getting an error. Below is my select statement and the error I am getting. Can you tell what I am missing? Thanks for the help.

SELECT Inventory.Descr, Inventory.InvtID, Inventory.User6
FROM Inventory
INNER JOIN OPENROWSET('SQLOLEDB',
'server=LOCAL;User id=x;password=123;
database=MEDex',
inventory) AS LocalInv
ON Inventory.InvtID = LocalInv.solomonid

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'emnsql02'. Reason:
Not associated with a trusted SQL Server connection.