Hi, ALL, Let's say I have a table with following data: field1 field2 field3 field4 1 2 3 4 5 6 7 8
How do I write a query which will produce the output as: 1 2 5 6 3 4 7 8 Is it possible to write a single query which will produce the output like this? And not just in SQLite.... Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users