Connect to the suitable instance of the SQL Server Database Engine in Object Explorer and expand the server tree Now, depending on the database, select a user database or expand System Databases Then select a system database and.

select * from user where (code + userType) in ( select code + userType from userType ). Then you have to manage nulls and concatenating numbers rather than adding them, and casting, and a code of 12 and a usertype of 3 vs a code of 1 and a usertype of 23, and.

So there ya go: a solution that doesn't.