T-SQL to check if a list of values returned from a query exists in another table's column : <p>I have a GUID assigned to a device where a user could sign in to multiple accounts.  Every time the app runs it registers the GUID and the UserId in a table.  The GUID will remain unique but could have multiple UserId's.</p>

<p>I have a second table that has subscriptions for each UserId.  </p>

<p>I need to find all UserId's returned from a search on the GUID and then see if any of those UserId's exist in the subscriptions table.</p>

<p>How do I do this using T SQL in MS SQL Server 2014?</p>

<p>Thank you.</p>
