Using the result of a query as a table name

Question

If we have table A as follows:

+-------+
+ Table +
+-------+

How would one perform a query involving values of A.table as the table name?

What I mean is something along the lines of this:

SELECT "Table" as "tbl" FROM "A";
SELECT * FROM "tbl";

but in one statement.

It would help if you could provide why the sample you provided isn't working for you. For instance, is it causing an error (and what's the error message)? — John M. Wright, Nov 22 '14 at 04:24
Take a look at this answer: http://stackoverflow.com/a/5668044/682840 I don't believe it's possible to do what you're looking for. — John M. Wright, Nov 22 '14 at 04:41

score 0 · Accepted Answer · answered Nov 22 '14 at 10:05

0

SQLite has no built-in mechanism to construct SQL statements dynamically; this is not possible.

(There is the eval extension, but it is not part of the default distribution.)

answered Nov 22 '14 at 10:05

CL.

1 Answers1