[Solved] SQLite how to refer to column name by a query

Question

I’m guessing from what little you have written that you want a variable list of fields (where the list of fields is retrieved from tableB) to be retrieved from tableA.

This isn’t possible directly in SQL. You will need to make 2 calls, the first one to retrieve the list of fields, and the second one where you have generated a SQL statement with an exoplicit list of fields from the first call.

Accepted Answer

I’m guessing from what little you have written that you want a variable list of fields (where the list of fields is retrieved from tableB) to be retrieved from tableA.

This isn’t possible directly in SQL. You will need to make 2 calls, the first one to retrieve the list of fields, and the second one where you have generated a SQL statement with an exoplicit list of fields from the first call.