Hello EH Do the "a2-style" (for want of a better way of defining them) names EH exist outside the SQL statement which defines them?
Tables and columns have fixed names, which you define when you write your database schema, e.g. CREATE TABLE myTable (id INT, value TEXT); But you can give these names aliases in your SQL statements: e.g. SELECT t1.id AS id1, t1.value AS val1 FROM myTable AS t1 INNER JOIN myTable AS t2 ON t1.id = t2.id; These aliases only exist in the statements that define what they are aliasing. You can't reuse them in other statements without again specifying what they are aliasing. If I've understood you, then what you should read up on is aliases. I hope this helps. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users