Hi,
I have a table A with a row called 'services' which contains the names
of other tables. What I want to do is to query table A and get from it
the name of table B which is then accessed.
What I tried is the following:
SELECT *
FROM (
SELECT service
FROM A
WHERE a_key = 1
)
The inner SELECT statements returns correctly the name of the table B
but the outer loop does not understand that it should treat the result
from the inner loop as a tablename rather than a result set.
Any ideas how I can solve this?
Thank you,
Christoph
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
