On 2 May 2010, at 3:22pm, Matt Young wrote: > I need to extract from an SQL table the names of other SQL tables and > reference them in a second query to build the proper series_id code:
Take a look at the section 'Pragmas to query the database schema' in http://www.sqlite.org/pragma.html There is more than one way to solve your problem, so look at the whole section before fastening on one particular solution. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users