Hi, I find the PRAGMA table_info(*tablename)* command very helpful. However, sometimes I want to extract table headers for a table constructed by a query which does not have the exact same headers as any one table in my database.
For example: Table 1 headers: A, B, and C Table 2 headers: a, b, and c Query: SELECT * FROM table1 JOIN table2; Is there any way to do something along the lines of PRAGMA some_command(SELECT * FROM table1 JOIN table2) and have it return A, B, C, a, b, c as the headers? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users