select 
heuserdeftext01 as keimeno1,
heuserdeftext02 as keimeno2,
heuserdeftext03 as keimeno3,
heuserdeftext04 as keimeno4,
heuserdeftext05 as keimeno5,
heuserdefnum01 as arithmitiko1,
heuserdefnum02 as arithmitiko2,
heuserdefnum03 as arithmitiko3,
a1.heName as pinakas1, 
a2.heName as pinakas2, 
a3.heName as pinakas3, 
a4.heName as pinakas4, 
a5.heName as pinakas5
From heItems 
Left Join heArraysItem a1 On a1.heCompID = heItems.heCompID 
And a1.heID = heItems.heUserDefArray01ID
Left Join heArraysItem a2 On a2.heCompID = heItems.heCompID 
And a2.heID = heItems.heUserDefArray02ID
Left Join heArraysItem a3 On a3.heCompID = heItems.heCompID 
And a3.heID = heItems.heUserDefArray03ID
Left Join heArraysItem a4 On a4.heCompID = heItems.heCompID 
And a4.heID = heItems.heUserDefArray04ID
Left Join heArraysItem a5 On a5.heCompID = heItems.heCompID 
And a5.heID = heItems.heUserDefArray05ID

where heItems.heid=@$Context$RefID