sql for two table

• Shantaram-260273

  Valued Member

  Points: 51

  More actions

  September 14, 2005 at 12:24 am

  #165974

  I have two table

  1> Master

  2 > Detail

  fields are

  Master : - code,Name , elcl _grant ,ol_grant

  Detail : code, elcl, ol

  e.g.

  data     code      Name        elcl_grant   Ol_Grant master : 1>1001 Shantaram       10            20

               2> 1002 Deepak        10             20

  Detail   :

                     code    elcl   ol

                     1001     2     0

                     1002     1     1

                     1002      3    0

  I want following result

  Name      Elcl Grant OL _Grant Elcl_given  Ol Given Shantaram   10              20           2               0

  Deepak        10              20          4               1

  Waiting for your valuable suggestion

• Meghana

  SSC Eights!

  Points: 860

  More actions

  September 14, 2005 at 1:08 am

  #589610

  SELECT Name, Elcl_grant, ol_grant, sum(elcl) as elcl_given, sum(ol) as ol_given

  FROM Master

  JOIN Detail ON master.code = detail.code

  GROUP by Name, Elcl_grant, ol_grant

   

  ---

  Regards,

  Meghana