select t1.code, t1.COMPANY, t1.AMOUNT ,t2.COMPANY, t2.AMOUNT from CHARGES t1, CHARGES t2 where t1.CODE = t2.CODE 如果同一个code 有多条数据,那么建议用存储过程解决
看起来只有AP,AR两个值,那么SELECT CODE, MAX(CASE WHEN AR_AP = 'AR' THEN COMPANY END), MAX(CASE WHEN AR_AP = 'AR' THEN AMOUNT END), MAX(CASE WHEN AR_AP = 'AP' THEN COMPANY END), MAX(CASE WHEN AR_AP = 'AP' THEN AMOUNT END) GROUP BY CODE;
CHARGES t1, CHARGES t2 where t1.CODE = t2.CODE
如果同一个code 有多条数据,那么建议用存储过程解决
MAX(CASE WHEN AR_AP = 'AP' THEN COMPANY END), MAX(CASE WHEN AR_AP = 'AP' THEN AMOUNT END)
GROUP BY CODE;