SQLTeam.com | Weblogs | Forums

Debit and credit match query


#1

Hı,

ID DEBIT CREDIT


1 1000 --------
2 ---- 500
3 ---- 200
4 ---- 100
5 ---- 500

I want to this result but dont cursor

ID_DEBIT ID_CREDIT AMOUNT


1 2 500
1 3 200
1 4 100
1 5 200
--- 5 300


#2
select isnull(d.id_debit, '---'),  isnull(c.id_credit, '---'), d.amount
from debit d
full join credit c
on d.amount = c.amount

#3

Hi

Please explain what you want "clearly"


#4

image


#5

Hi

Sorry

I am able to see the data
Please explain what you are looking for

Example
Data
1 100 a
2 200 b

I want to add
1 + 200 then
200 - 2
equals

Some thing Like this

Looking at the data
no idea what you want to do

If i understand what you are wanting
how the data should be manipulated
to get the final output

I can work on the SQL to get the desired result