USE SRO_VT_ACCOUNT Go DECLARE @CharName varchar (max) = 'Name' DECLARE @CharID int = (Select CharID From SRO_VT_SHARD.dbo._Char Where CharName16 = @CharName) Select * From SK_Silk Where JID in (Select JID From SRO_VT_SHARD.dbo._User Where CharID = @CharID)