I am attempting to run this syntax
Select [StoreName] = (Select * FROM OPENQUERY(192.168.5.812,'Select storename FROM stores') x WHERE x.storename = y.storename) [StoreManager] = y.storemanager FROM managerinfo y
But this gives me an error of
Msg 116, Level 16, State 1, Line 28
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Is it possible to do this while using
OPENQUERY? How can I achieve my desired result?