On 5/29/2012 4:44 PM, Gert Van Assche wrote:
I have a strange table like this
rowid; Field1x; Field2y; FieldAx; FieldBy
1; A; a; 0; 1
2; B; b; 4; 2
and I would need this:
rowid; Field3; FieldC
1; A; 0
2; a; 1
3; b; 2
4;
Sent: Tuesday, May 29, 2012 4:44 PM
Subject: [sqlite] rearranging 2 fields into 1 based on an order indicator in 2
other fields
All,
I have a strange table like this
rowid; Field1x; Field2y; FieldAx; FieldBy
1; A; a; 0; 1
2; B; b; 4; 2
and I woul
All,
I have a strange table like this
rowid; Field1x; Field2y; FieldAx; FieldBy
1; A; a; 0; 1
2; B; b; 4; 2
and I would need this:
rowid; Field3; FieldC
1; A; 0
2; a; 1
3; b; 2
4; B; 4
So:
- the contents of
3 matches
Mail list logo