before, sorry for my poor english.

I have a table like this :

RID REK JNR ANG
-------------------------
001 0005 491 500
002 0010 321 250
003 0005 491 100
004 0012 112 200
005 0012 321 300

I want to create result like this :

REK 112 321 491 TOT
----------------------------
0005 600 600
0010 250 250
0012 200 300 500

The question is how to create the query ???



Thanks in advance

.: SyamSyah :.


[Non-text portions of this message have been removed]