declare @itemcode varchar(20)
set @itemcode = 'IIII'

if (select count (*) from Rdb_log_cust_account where Rdb_log_cust_account.sz_customer_no = @itemcode) > 0
begin
	select customer.sz_customer_no as Customer_code,
	customer.SZ_CUSTOMER_FNAME as Customer_fname,
	customer.sz_customer_lname as Customer_lname,
	cust_account.n2_balance_value as Customer_pointEarned,
	sum(Rdb_log_cust_account.N0_POINTS) as Customer_pointUsed,
        customer.sz_cash_mobile_code as Customer_mobyleNickname
	from  customer,cust_account, Rdb_log_cust_account
	where
	        customer.sz_customer_no = @itemcode and
	        customer.sz_customer_no = cust_account.sz_customer_no and
	        customer.sz_customer_no = Rdb_log_cust_account.sz_customer_no and
	        Rdb_log_cust_account.sz_action ='ADD'
	group by
	        customer.sz_customer_no,
	        customer.SZ_CUSTOMER_FNAME,
	        customer.sz_customer_lname,
	        cust_account.n2_balance_value,
	        cust_account.n2_balance_used,
                customer.sz_cash_mobile_code

end	        
else
	select customer.sz_customer_no as Customer_code,
	customer.SZ_CUSTOMER_FNAME as Customer_fname,
	customer.sz_customer_lname as Customer_lname,
	cust_account.n2_balance_value as Customer_pointEarned,0 as Customer_pointUsed,
        customer.sz_cash_mobile_code as Customer_mobyleNickname
	from  customer,cust_account
	where
	        customer.sz_customer_no = @itemcode and
	        customer.sz_customer_no = cust_account.sz_customer_no 
	group by
	        customer.sz_customer_no,
	        customer.SZ_CUSTOMER_FNAME,
	        customer.sz_customer_lname,
	        cust_account.n2_balance_value,
	        cust_account.n2_balance_used,
                customer.sz_cash_mobile_code

