Re: [sqlite] rearranging 2 fields into 1 based on an order indicator in 2 other fields

2012-05-29 Thread Igor Tandetnik
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;

Re: [sqlite] rearranging 2 fields into 1 based on an order indicator in 2 other fields

2012-05-29 Thread David Bicking
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

[sqlite] rearranging 2 fields into 1 based on an order indicator in 2 other fields

2012-05-29 Thread Gert Van Assche
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