Select CodeName128 and display all item drops from that mob

[JZersche]

Use SRO_VT_SHARD select RefItemID from _RefMonster_AssignedItemDrop where RefItemId like '%' AND select CodeName128 from _RefObjCommon where CodeName128 like 'MOB_CH_MANGNYANG'


I can't figure out how to do this, but this is what I want to accomplish. I want to basically select a MOB by it's CodeName, then show all RefItemID's that the RefMonsterID is synced to.

so like,
MOB_GOD_PILLAR_ENVY_DROP_100_11
Then it shows every Item this mob drops.. by name, and maybe ID also if possible.

[Dragonz2105]

maybe try this

SELECT RefItemID FROM _RefMonster_AssignedItemDrop WHERE RefMonsterID in ( SELECT ID From _RefObjCommon WHERE CodeName128 Like 'MOB CODE')

[JZersche]

Solution:

SELECT CodeName128 , (SELECT CodeName128 FROM [dbo].[_RefObjCommon] WHERE ID = 3877) as MONSTERNAME FROM _RefObjCommon WHERE ID IN (SELECT RefItemID FROM _RefMonster_AssignedItemDrop where RefMonsterID = 3877)