Hi,

Currently I am developing a system which import data from a Interbase
Database and I have an 'odd' idea about something and would like some
opinions and advice with it

I have a table as follows:
ID,field1,field2
1,a,val1
2,a,val6
3,a,val15
4,b,val9
5,b,val11
6,b,val4
7,c,val21
8,d,val3
9,e,val17

What I need is a table as follows

ID,field1,occ1,occ2,occ3
1,a,val1,val6,val15
2,b,val9,val11,val4

Is this at all possible or do i need to approach this entirely different?

Thanks in advance,

Serge Fonville


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