Average grouping by serial number in script, how to?

[#1]

Hey guys,

I have a field called "Serial Number", and another one called "Flight time", I would like to make a Flight Time average per serial number, in the script...

How do I create that??

[MK_QSL]

MainTable:

Load

     [Serial Number]

     [Flight time]

     anotherField1

     anotherField2

From TableName;

Join

Load

     [Serial Number]

     Avg[Flight time] as AvgFlightTime

Resident MainTable

Group By [Serial Number];

[#3]

Please use Left Join instead of Join