Nested query is not supported in SQLite

Question

I use an SQLite database on my iPhone application and i need to perform a task that require a nested query. However, my query seems not working, i have googled it and i found that SQLite doesn't support Subquerys. Is there any solution?

EDIT: This is the query that doesn't work for me:

select count(*) from quiz where theme=(select id from theme where nom="Houses") and etat=0;

SQLite supports subqueries. Can you post an example of a query that doesn't work? — Nick Dandoulakis, Mar 02 '12 at 09:02

score 5 · Answer 1 · answered Mar 02 '12 at 09:16

5

If the subquery (select id from theme where nom="Houses") returns multiple rows,
the theme = wont work. You must use theme IN instead.

select count(*) from quiz where theme IN (select id from theme where nom="Houses") and etat=0;

answered Mar 02 '12 at 09:16

Nick Dandoulakis

42,588
16
104
136

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

you can use joins instead of nested query, that will work.

for reference please check this...

Nested statements in sqlite

edited May 23 '17 at 11:59

Community

1
1

answered Mar 02 '12 at 08:59

shofee

2,079
13
30

Nested query is not supported in SQLite

2 Answers2