that gave me an incorrect syntax error near ; . I assume it is because the connection string needs to be tied together. I tried a few alterations to this statement, but I still get the same error, invalid login.

SELECT Inventory.Descr, Inventory.InvtID, Inventory.User6
FROM Inventory
INNER JOIN OPENROWSET('SQLOLEDB',
'(local)';'x';'123';'select * from medex..inventory') LocalInv ON
Inventory.InvtID = LocalInv.solomonid