JOINGING MORE THAN TWO TABLES

• razack.ora

  Grasshopper

  Points: 17

  More actions

  January 25, 2011 at 2:06 am

  #232630

  Hi all,

  We have a emplyee table to keep tracks of his rewarded points for bonus calculation...

  suppose if a employee A joined on 2005 jan and he s active till jan2011

  each month has its own seprate table to store the points for him.

  now we want to sum the values of a one column(say : point value)of all tables ranging from 2005jan to 2011 jan.

  How can i do that....Please help

• Mike John

  SSCertifiable

  Points: 7216

  More actions

  January 25, 2011 at 2:12 am

  #1277665

  If possible I would rethink the database design - specifically why have a separate table for each months points?

  With the separate table you will need to change the query each month to "union" another monmths table.

  Much easier would be one table with all the points, and a column indicating the month they apply to.

  Mike