SELECT MobInfo.Name, MobInfo.Level as MLevel, MobInfo.ID, WeaponTitleData.LLevel, WeaponTitleData.Suffix
FROM MobInfo
JOIN(
SELECT MobID, Level as LLevel, Suffix 
FROM WeaponTitleData 

ORDER BY LLevel DESC
) AS WeaponTitleData 
ON MobInfo.ID = WeaponTitleData.MobID
GROUP BY MobID
ORDER BY MLevel