Drunk man who went 'missing' joins search party looking for himself