I have as the followings...
create table t ([a] varchar(3), [b] varchar(3));
insert into t(a, b) values('6', '2');
insert into t(a, b) values('5', '3');
insert into t(a, b) values('2', '3');
create table t2([x] varchar(9));
insert into t2(x) select (a || ', ' || b) from t;
but I want t2.x sorted as '2, 6' , '3, 5', '2, 3' instead of '6, 2', '5, 3',
'2, 3'.
Please, help. Thank's.
--
View this message in context:
http://old.nabble.com/sort-a-contenated-value-as-inserting-tp32550882p32550882.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
