I'm not sure where the issue is, without seeing your code. I built a small sample in SQLFIddle:

SQLFiddle

It's giving me the same result as you have in your post:

IDPARENT    COLUMN_1    COLUMN_2
1            28.25          9.5