Select bb.거래처코드, 매출, isnull(입금, 0), 매출-isnull(입금,0) as 차액

From (Select 거래처코드, sum(매출금액) as 매출

FRom 매입테이블 as aa

GRoup by 거래처코드) as bb

Left join

(Select 거래처코드, sum(입금금액) as 입금

FRom 입금테이블 as cc

GRoup by 거래처코드) as dd

on bb.거래처코드 = dd.거래처코드

WHere 매출 - isnull(입금, 0) > 0

--첫 스마트폰 구입기념 댓글 써봤는데 너무 빡시군요.ㅋ

축하드려요^^

답변감사합니다. 

create table income

(code varchar(5),

income int)

insert into income values

('a', 1000),('b',2000),('c',2000),('a',3000)

create table deposit

(code varchar(5),

deposit int)

insert into deposit values

('a',1000),('b',2000),('c',1000),('a',1000)

select * from income

select * from deposit

create clustered index income_code on income(code)

create clustered index deposit_code on deposit(code)

select a.income as 총매출액, b.deposit as 총입금액, a.income-b.deposit 차액

from

(select code, sum(income) income

from income with (nolock)

group by code

)a inner join

(select code, SUM(deposit) deposit

from deposit with (nolock)

group by code) b

on a.code=b.code

where a.code='a'