tableA key math 1 70 3 20 5 40 7 50 tableB key korean english 1 90 5 2 40 20 3 80 100 4 70 40 5 80 80 이 두 테이블에서 math와 korean의 합을 구하려면.. 생각해봐도 ㅡ.ㅡ; 아무튼 원하는 결과는...... tableC key math+korean 1 160 2 40 3 100 4 70 5 120 7 50 인데..... 너무 어렵네요...ㅡ.ㅡ 도와주세요
select a.key, isnull(a.math,0)+isnull(b.korean,0)
from tableA a
join tableB b on a.key=b.key
union
from tableB a
left join tableA b on a.key=b.key
where b.key is null
감사합니다....^^ select a.key, isnull(a.math,0)+isnull(b.korean,0) from tableA a join tableB b on a.key=b.key union select a.key, isnull(a.korean,0)+isnull(b.math,0) from tableB a left join tableA b on a.key=b.key where b.key is null 조금 수정해서 잘 해결됬네요 ^^