Matching Month('date') with Inline Month

[#1]

Can anyone teach me how to match the month that is generated by the "month" function with the one that is from the Inline table?

When I just load it as per normal with joining the tables, duplication appears but when I used "Left Join", my items in the Inline table disappears.

Is that not the right way to do so?

My code is as follows:

Left Join(Jobworkhrdata)

LOAD month([Posting Date]) as workmonth,

      year([Posting Date]) as workyear,

      [No_],

      Sum([Hour X 1_0]) as 1,

      Sum([Hour X 1_5]) as 2,

      Sum([Hour X 2_0]) as 3

      GROUP BY [No_], month([Posting Date]), year([Posting Date]);

SELECT [Job No_],

      [Posting Date]

      ,[No_]

      ,[Hour X 1_0]

      ,[Hour X 1_5]

      ,[Hour X 2_0]

  FROM database

  where [Type] = '0' and [Job No_] like 'J______'

  ;

//Left Join (Jobworkhrdata)

  LOAD * INLINE [

    workmonth, workMonth, Manhour

    Jan, 1, 167

    Feb, 2, 185

    Mar, 3, 193

    Apr, 4, 177

    May, 5, 194

    Jun, 6, 184

    Jul, 7, 194

    Aug, 8, 184

    Sep, 9, 176

    Oct, 10, 195

    Nov, 11, 174

    Dec, 12, 168

];