Matt,
You cannot select a column from a relation if the relation does not include
the column. The query inside the ( ) returns a single column, table_id.
select a_format
from
(
select table_id
from table_id_list
where prefix_code = 'MyPrefix_code'
);
However, if table_id corresponds to a_format,
Thanks,
I eventually ended up doing something like that,and got it working.
I booked marked the your example and will try variations of it.
I got most of my system working, but I am still overwhelmed with
economic data releases from around the word.
On 5/3/10, Tim Romano tim.romano...@gmail.com
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
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
