On 29 September 2011 07:35, guiz <guizaw...@gmail.com> wrote:
>
> 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.
insert into t2(x) select min( a, b ) || ', ' || max( a, b ) from t;
>
Regards,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
