Need help to make this query

• noor3rb

  Grasshopper

  Points: 10

  More actions

  May 15, 2010 at 1:53 am

  #386936

  Hi everyone , i need help to do this query as i have two tables in database

  1- First Table called "Accounts" which have the following fields

  AccountIDAccountNameParentIDLevel

  1x null0

  2x111

  3x1122

  4x11133

  5x11233

  6x1222

  7x12163

  8x12263

  9x12363

  10x211

  11x21102

  12x211113

  13x2111124

  14x2112124

  15x2113124

  16x22102

  17x221163

  18x222163

  19x223163

  20x311

  and the second table called "AccountBalance" which has the following fields :

  AccountIDAccountNameDebitCredit

  4x1111010

  5x1121010

  7x121015

  8x122150

  9x1232030

  13x2111100

  14x21122030

  15x21135040

  17x2217422

  18x2225050

  19x2237080

  now i want to make a sql query to get sum of each level to give me this result

  AccountIDAccountNameDebitCredit

  1x429407

  2x15565

  3x112020

  4x1111010

  5x1121010

  6x123545

  7x121015

  8x122150

  9x1232030

  10x2324282

  11x218070

  12x2118070

  13x2111100

  14x21122030

  15x21135040

  16x22244212

  17x2217422

  18x2225050

  19x2237080

  20x35060

  so how can i get this result

  please help me to do this .....

  thanks alot for help

• LutzM

  SSC Guru

  Points: 107049

  More actions

  May 15, 2010 at 2:12 am

  #1167885

  duplicate post.

  Please continue discussion here.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]