I am a bit of a novice. I am dealing with meta data, descriptions of the Bureau of Labor Statistics database. BLS data is identified by a series code (16 chars long) but the series format is different for each data group)
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: I haven't tried this, I assume it can't be done: select a_format from (select table_id from table_id_list where prefix_code = 'MyPrefix_code'); Is this beyond SQL? Is there a better solution? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users