1.Select GameShop_name
2., Item_name = Isnull((Select Item_name From WEB_Reward_Item Where Web_Reward_Item_id
3.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
4.in (Select Gamemenu_prize_id From Gamemenu_prize Where GameShop_id = a.GameShop_id))),'')
5.From View_Gameshop a
6.Where GameShop_Zone_id = 2
