Hello, Is it possible to create a view which switches rows and columns of a dynamically changing table?
For example, imagine we have table t1 where both columns and rows could change after the view has been created sqlite> select * from t1; Product/Region|Belgium|France|USA Oil_filter|1|2|3 Spark_plug|4|5|6 Coolent|7|8|9 Could view v1 be created such that sqlite> select * from v1; Product/Region|Oil_filter|Spark_plug|Coolent Belgium|1|4|7 France|2|5|8 USA|3|6|9 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users