Re: 3 Table Query

[O'henry Henry]

Table C
AccountCode
100
101
102
103
104
105


Table A
Tcode--ACode --Amount
1---------100------100.00
1---------101 -----130.00
1---------102------150.00
0---------103------160.00
0---------104------200.00
0---------105------300.00

Table B
Tcode--ACode--Amount
0-------- 100------2100.00
0---------101-----4100.00
0---------102-----1100.00
1---------103-----3100.00
1---------104-----4100.00
1---------105-----5100.00



Filter out transactioncode = 0

---------------A --------------------------- B ------------------------ C
Tcode--ACode --Amount--- Tcode--ACode--Amount -----AccountCode
nul-------100---------nul-------- 0------ 100-----2100.00-------100
nul-------101 --------nul---------0-------101----4100.00--------101
nul-------102---------nul---------0-------102----1100.00--------102
0---------103------160.00-------nul-----103-------nul-----------103
0---------104------200.00-------nul-----104-------nul-----------104
0---------105------300.00-------nul-----105-------nul-----------105

Can this be generated Guys on Sql as you can see all records from Table C r displayed except on Table b and A
Theres null value because i'd made a filter that only Tcode=0 should be displayed.

Thanks Guys for your help it meant a lot to us!!!

God Bless...