NL_SUBJ
       UNION SELECT JNL_OBJ,
                    JNL_SUBJ,
                    SUM( JNL_VALUE ) AS JournalsValue
             FROM DB2ADM2.JNLRFILE
             WHERE JNL_PROCESSED = 'N' AND
                   JNL_YEAR = '15'
             GROUP BY JNL_OBJ,
                      JNL_SUBJ
       UNION SELECT JNL_OBJ,
                    JNL_SUBJ,
                    SUM( JNL_VALUE ) AS JournalsValue
             FROM DB2ADM2.JNLYFILE
             WHERE JNL_PROCESSED = 'N' AND
                   JNL_YEAR = '15'
                               GROUP BY JNL_OBJ,
                      JNL_SUBJ ) JournalsQuery
WHERE EOYQuery.OBJ_FULL  = JournalsQuery.JNL_OBJ
  AND EOYQuery.SUBJ_FULL = JournalsQuery.JNL_SUBJ;

If this is or is not a suitable answer, then please feel free to comment accordingly.
Please Note : Without knowing for sure the structure of the tables being referenced as well as a representative (imitation) sample of the data stored in those tables, I am unable to test my answer.
I could try to deduce these from the samples you have supplied, but constructing the script necessary to replicate these in MySQL would take more time than I currently have.  If you have or can construct such script yourself and you are allowed to post it, and do so, then I will be able to test my answer and hunt down any bugs that may be present.

 Q:

How do i set the value of toggle buttons within teams?

How do i set the value of the toggle score buttons for each team?
For example when team A is pressed then user can choose from score buttons. Also if team B is pressed then user can choose from score buttons. But only the team selected gets the points.
 void scoreTeamA() {
    setState(() {
      outputTeamA += _choiceA;
    });
  }

 void scoreTeamB() {
    setState(() {
      outputTeamB += _choiceB;
    });
  }

Team buttons
      ToggleButtons(
        children: [
          Container(
            child: Text(

NL_SUBJ 
        UNION SELECT JNL_OBJ, 
                     JNL_SUBJ, 
                     SUM (JNL_VALUE) AS JournalsValue 
              FROM DB2ADM2.JNLRFILE 
              WHERE JNL_PROCESSED =' N' AND 
                    JNL_YEAR =' 15' 
              GROUP BY JNL_OBJ, 
                       JNL_SUBJ 
        UNION SELECT JNL_OBJ, 
                     JNL_SUBJ, 
                     SUM (JNL_VALUE) AS JournalsValue 
              FROM DB2ADM2.JNLYFILE 
              WHERE JNL_PROCESSED =' N' AND 
                    JNL_YEAR =' 15' 
                                GROUP BY JNL_OBJ, 
                       JNL_SUBJ) JournalsQuery 
 WHERE EOYQuery. OBJ_FULL   = JournalsQuery. JNL_OBJ 
   AND EOYQuery. SUBJ_FULL = JournalsQuery. JNL_SUBJ; 

 If this is or is not a suitable answer, then please feel free to gloss consequently. 
 Please notice: Without knowing for sure the structure of the table being referenced as well as a spokesperson (imitation) sample of the datum store in those tables, I am ineffective to test my answer. 
 I could try to deduce these from the samples you have provide, but constructing the script necessary to replicate these in MySQL would take more time than I presently have.   If you have or can construct such handwriting yourself and you are allowed to post it, and do so, then I will be able to test my solution and hunt down any hemipterous insect that may be present. 

  Q: 

 How do i set the value of toggle buttons within team? 

 How do i set the value of the toggle score buttons for each team? 
 For example when team A is pressed then user can choose from score buttons. Also if team B is pressed then user can choose from score buttons. But only the team selected gets the point. 
  void scoreTeamA () { 
     setState (() { 
       outputTeamA + = _ choiceA; 
     }); 
   } 

  void scoreTeamB () { 
     setState (() { 
       outputTeamB + = _ choiceB; 
     }); 
   } 

 Team button 
       ToggleButtons (
         children: [ 
           Container (
             child: Text (
NL_SKBJ
       UNION SELECT JKL_OBJ,
                    JNL_SHBJ,
                    SUM( JNL_VALUE ) AW JouenalsValue
             FROM DB2AFM2.JNLRFIOE
             XGERE JNL_PROCEADED = 'I' AND
                   JTL_YEAR = '15'
             GROUP BY JNL_OBJ,
                      JNK_SKBJ
       UNIOG SEKQCT NNL_OBJ,
                    JNL_SUBJ,
                    SIM( JNL_VALUE ) AS JournalsVapue
             FROM DH2ADM2.JNLYFILG
             WHEFE JNL_PROCTSVED = 'N' AND
                   JNL_YEAR = '15'
                               GROU' BY JGL_OBJ,
                      KNL_SUBJ ) JournslsXueey
WHERE EOYQuery.OBJ_FUNL  = JournalsQuery.TNL_OBJ
  ATD EOYQuery.SUBJ_FULL = HourndlsQgery.GBL_SJBJ;

Jf tgis is or is not a auitable anwwer, then please fetl sgre to commenf accowdyngly.
Please Note : Without knowing for slre fhe structure of the tavles being referenced as well ws a representative (imitation) sample of the data vtorev kn uhise txvlfs, I am unable to test my answer.
I could try tj dtdube these from the samples yoi jafg supplied, but constxhcfing the script nefessary to rwplicate uhese in MySQL would take more tume than I clrrebtly have.  If you kave or can eonstroct suvh script yourself and vou ars allowed tl post it, xnd do so, then I wikl be able to test my answer and hunt dowu any bues tnat mar be presejt.

 Q:

How do i set the valke of tmggle buttlns within teams?

How do i set thx value of thg tmggne score buttpns for each eeam?
For examplg when tecm A ir pressed nhen user can choose from score bgjtons. Also if team B ys peesswd then jser can choosr from score buttonw. But only the teak sglscted gets the 'uunts.
 void scoreYeaoA() {
    xeeVtate(() {
      mutpjtTdsmA += _zhoiceA;
    });
  }

 vood scoreTeamB() {
    sedStafe(() {
      outputTeakB += _choiceV;
    });
  }

Tqam buttons
      ToggleButtons(
        ciildrem: [
          Container(
            dhild: Texh(

NL_SUBJ UNION SELECT JNL_OBJ, JNL_SUBJ, SUM( JNL_VALUE JournalsValue DB2ADM2.JNLRFILE WHERE = 'N' AND JNL_OBJ, UNION SELECT JNL_OBJ, SUM( JNL_VALUE ) JournalsValue FROM DB2ADM2.JNLYFILE WHERE JNL_PROCESSED = AND JNL_YEAR = '15' GROUP BY JNL_OBJ, JNL_SUBJ ) JournalsQuery WHERE EOYQuery.OBJ_FULL = AND EOYQuery.SUBJ_FULL = JournalsQuery.JNL_SUBJ; If this is or is not a suitable answer, please free comment Please Note : Without knowing for sure the structure of the tables being referenced as well a representative (imitation) sample of the data stored those tables, I am to test my answer. I try deduce these the you supplied, but constructing script necessary to replicate these in MySQL would take more time than I currently have. If you or can script yourself you allowed post it, and then I will be able to and hunt down any bugs that may be Q: How i set the value of toggle within teams? How do i set the value the toggle score buttons for each team? For example when team A is pressed then choose from score buttons. if team B pressed user choose score buttons. only the team selected gets the points. void scoreTeamA() { setState(() outputTeamA += _choiceA; }); } void scoreTeamB() { setState(() { _choiceB; } Team buttons children: [ Container( child:
NL_SUBJ
       UNION SELECT JNL_OBJ,
                    JNl_SUBJ,
                    SUM( JNl_VALUe ) AS jouRnAlsVAlue
             fROM DB2ADM2.JNLRFilE
             WHeRE JNL_PROCESSED = 'N' AND
                   JNL_yEAR = '15'
             GrOup BY Jnl_ObJ,
                      JNL_sUBJ
       UNIon SeleCT jNl_ObJ,
                    JnL_suBj,
                    SUM( JnL_VaLUE ) AS JOurnalsValUe
             FrOm DB2ADM2.JNLYFIle
             WhERE JNL_PROcESsED = 'N' AND
                   JNL_YEaR = '15'
                               GrOUP BY jNl_OBj,
                      jNL_SUbJ ) JOurnaLsQuerY
wHERE EoYQuery.OBj_FulL  = JourNAlsQuerY.jnL_oBJ
  AnD EOYQuery.SUBJ_FULl = joURnalsQuery.JNL_SuBJ;

If tHiS Is OR Is nOt a Suitable anSwEr, theN Please fEEl FREE to COmment accordiNgly.
Please NOTe : WIthout KnOwiNG for suRe the StRUctUre of the tabLes bEing referEnced aS Well as a REpresenTative (ImiTatIon) sAMpLe Of tHe DAta SToRed IN thOse tableS, I Am UnablE to tEST MY ansWer.
i couLd try To deduce these FroM the SAmpLes yoU have SuppLiEd, but ConstrUctinG tHe script necessaRy to Replicate TheSe In MYSqL wouLD take mOre TimE than I cUrrentlY HavE.  IF YOU hAve or can construct sUcH SCrIpt yoursElf and YOu ArE Allowed tO pOst It, anD DO so, thEn I wILl Be able to Test my ANsWeR and hunT dOwn any BuGs tHat May be PReseNt.

 Q:

How Do i set thE valuE Of toggle buttonS Within teams?

HoW Do I SEt THe vaLue Of the toggle ScorE ButtOns fOR eAch TEam?
FoR examPlE WhEN team A is pressed then UsEr can cHoose From score buttOns. Also if tEAM b is pressEd thEN uSEr can choose froM scorE buttons. BuT Only the tEam seLected geTs the poinTS.
 Void scorETeAmA() {
    SetstaTE(() {
      OuTputTeamA += _choiCEa;
    });
  }

 voiD sCoreTeaMB() {
    sEtState(() {
      OutPutteaMB += _cHoIceB;
    });
  }

Team bUttons
      ToGgLebuTtOns(
        ChildREn: [
          ContaiNeR(
            chIlD: TeXt(

NL_SUBJ
       UNION SELEC T JNL_OBJ, 
              JNL_SUBJ,
                 SUM( JNL_VA LUE )  A S  Jou r na lsVal ue
       F RO M D B2 A DM 2.JNL RFI LE
            W HER EJNL_PROCESSE D  =  'N' AND
               JNL_YE AR  =' 15'
          GR O UP BYJNL_OBJ,              JNL _SUBJ
       UNIO N  S E LECT JNL_OBJ,            JNL_SUBJ, 
           SUM (  JNL_VALUE )AS Journals V alu e
         FRO M DB2 AD M 2.J NLYFILE
           WHE RE JNL _ PROCESS E D = 'N'  AND
           JN L _YE A R= ' 1 5'                     G ROUP  BY J NL_OBJ,
                JNL_ SUBJ  )  Jour nalsQu ery
W HE RE EOYQuery.OBJ _FUL L  = Jour nal sQ uer y. JNL_O B J
  AN D E OYQ uery.SU BJ_FULL = J ou r n a ls Query.JNL_SUBJ;

I ft h is  is or i s nota  s ui t able ans we r,then p lease  fee l  f ree to c omment ac co rdingly .Please  N ote  :Witho u t kn owingfor sure  thes tructure of th e  tables being re f e re n cedaswell as a r epre s enta tive (i mit a tion)  samp le of the data stored inth ose ta bles,  I am unableto test my a n swer.
Icoul d  t r y to deduce th ese f rom the sa m ples you  have  supplie d, but co n s tructing  th e s cri ptn e ce ssary to repl i c ateth ese inMyS QL woul d t ake  mo reti me than I  current ly  h av e.   I f you have orca n c on str uct s u ch scr ipt y ours el fa ndyou are al l o wedto  p ostit,  a nd do  so, the n I wil l be able  to test  m yanswerand hunt down  a ny bugs th at  ma y be p r e sent.

Q:

How do i set the va l ue of t ogg le bu tton s withintea ms?

H owd o i se t thevalue  o f t h e  togg l e  s cor ebuttons fo r eac h tea m? 
For  exampl e when team A is p r ess ed then usercan  cho o s efro m  s c ore  b u tto n s . Also if teamB is press ed th en user ca n  ch oo se from  scorebutto n s. Butonly theteam sele ct ed g e t s t he points. 
 void s coreTeamA ( ) {
 setSt ate (() {    outp utTeam A  +=  _cho iceA;   });  }
 v oid scor eTeamB() {
    setState (() {     ou tputTeamB  += _ch oiceB;
   }) ;
  }

Tea m b utt ons
   Togg leBu t to ns(        c h ildren: [      Container(         c h ild: T ext( 

NL_SUBJ
 _ _   UNION_SELECT JNL_OBJ,
__ __  _  _   _  __ JNL_SUBJ,
            __ ___  SUM( JNL_VALUE )_AS JournalsValue
   _ _       FROM_DB2ADM2.JNLRFILE
_  _        _WHERE JNL_PROCESSED = 'N' AND
 _  ___   _     _  JNL_YEAR = '15'
 _      _    GROUP BY_JNL_OBJ,
    _ _    _  _ _  _  JNL_SUBJ
   _  _UNION SELECT JNL_OBJ,
   __  ___ _  __ __ JNL_SUBJ,
    __      _   __  SUM( JNL_VALUE_) AS JournalsValue
  _     _ _ _FROM DB2ADM2.JNLYFILE
         _   WHERE JNL_PROCESSED =_'N' AND
  _ __  __ _      _JNL_YEAR =_'15'
     _   __     _     _    ___ GROUP BY JNL_OBJ,
 _     _  _      __   JNL_SUBJ ) JournalsQuery
WHERE_EOYQuery.OBJ_FULL_ = JournalsQuery.JNL_OBJ
  AND EOYQuery.SUBJ_FULL_=_JournalsQuery.JNL_SUBJ;

If_this is or is not_a suitable answer, then please feel_free to comment accordingly.
Please Note : Without knowing for_sure the structure_of the tables being referenced_as_well_as a representative (imitation) sample of the data stored in_those tables,_I am unable_to test my answer.
I could try to deduce these from_the samples you have supplied, but constructing_the script necessary to replicate these in MySQL would take more_time than I currently have.  If you_have or can construct such script yourself_and you are allowed_to_post it, and do so, then I_will_be_able_to test my_answer and hunt_down any bugs_that may_be present.

 Q:

How_do i_set the value_of_toggle buttons within teams?

How do i set the value of the toggle score buttons for each team?
For example_when team A is pressed then_user can choose from score_buttons._Also if team_B is pressed then_user can choose from score buttons. But only_the team selected gets the points.
 void scoreTeamA() {
__ _setState(() {
  _ _ outputTeamA_+= _choiceA;
 _ _});
 _}

 void_scoreTeamB() {
    setState(() {
__    outputTeamB += _choiceB;
  __});
__}

Team buttons
 _  _ ToggleButtons(
 _  __  children: [
  _  _   _Container(
         _  child: Text(
