>SELECT a.case_no, a.eng_name, a.chi_name, b.cash, b.credit, b.eps from income_log a INNER join ; >(select case_no, sum(IIF(Paid_Type="V", paid, 0)) as Credit, sum(IIF(Paid_Type="$", paid, 0)) as CASH, sum(IIF(Paid_Type="E", paid, 0)) as EPS FROM income_log group by case_no) b ; >on a.case_no = b.case_no into cursor income_output order by 1 >>