Select GameShop_name
, Item_name = Isnull((Select Item_name From WEB_Reward_Item Where Web_Reward_Item_id
in (Select Web_Reward_Item_id From Web_Reward_Redeem_itm Where Web_Reward_Item_id = WEB_Reward_Item.Web_Reward_Item_id and Gamemenu_prize_id
in (Select Gamemenu_prize_id From Gamemenu_prize Where GameShop_id = a.GameShop_id))),'')
From View_Gameshop a
Where GameShop_Zone_id = 2
มัน ขึ้น ว่า
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Load balance : Server 04
