sql - mysql left join and sum group by -


Hi I am using this mysql code to generate this data below:

Code:

SELECT L.LEAVETYPE, LA.IDLEAVETYPE, LA.IDLEAVETABLE, S LEA (LA.NOOFDAYS), excluding L.E. as LEAVETYPE, LA.IDLEAVETYPE = L. Lilavitipable Group L with LAP Laupetable by LETETE.

alt text

Where do I place it Where to show LeaveType with only the value I like how to zero (like the first picture) Can also show leavetype? LA as leapelipation by leaving LEAVETYPE AS L from 

  SELECT L.LEAVETYPE, LA.IDLEAVETYPE, LA.IDLEAVETABLE, SUM (LA.NOOFDAYS). IDLAVEEPE = L. IdleWeePatable LA IDSTABLETABLE = '24' GROUP BY L.L.V.T.PE  
 alt text < / P>  
 
 
 Move the position of idstaff place instead of being in place of:  
  LE.INLEAVETYPE = LA.IDLivePABLE and LA.IDSTAFFTABLE = '24' to leave as LA.

Comments

Post a Comment