Can I make a simple "select in" statement using simpleDb
Ex: SELECT * FROM Domain WHERE id in (1,2,3)
thanks.
Asked
Active
Viewed 65 times
1 Answers
0
Yes you can do it. You can use IN syntax like this.
Shivam
- 702
- 2
- 10
- 25
-
can i use subqueries? Ex: SELECT * FROM Domain WHERE id in (SELECT id FROM OtherDomain) – Jean Toledo Feb 11 '14 at 10:45
-
Yes you can use subquery also. – Shivam Feb 11 '14 at 10:45
-
SELECT * FROM tv_twilio_call_log WHERE id IN (SELECT id FROM tv_crm_studentdetails WHERE id IN (1,2,3)); – Shivam Feb 11 '14 at 10:50
-
This is my query and it's working fine, check your syntax are correct or not. – Shivam Feb 11 '14 at 10:51
-
Down't work: SELECT * FROM `conteudo-generico` WHERE Codigo IN (SELECT Codigo FROM `conteudo-generico` WHERE ItemName() = '3') – Jean Toledo Feb 11 '14 at 10:53
-
codigo should be an id – Shivam Feb 11 '14 at 11:26