select sum(stock) from ona_item where s_cd='04' and (itemtype='B' or itemtype = 'D') and stock>0

³îÀ̾ƶì

¡°µµ¼­,½Ãû°¢ÀÚ·á´Â ¹è´Þ¿¹¾àÀÌ ºÒ°¡ÇÕ´Ï´Ù¡±
ÃÑ º¸À¯Ç°¸ñ 1Á¾ 2 °³ / °Ë»ö°á°ú 2Á¾ 1 °³

°ü·Ã¹è³Ê