Can you have more than one subquery in a where clause?

Question

I don't have an example for this but I was just wondering if something like this is valid in any situation:

SELECT somefield
FROM sometable
WHERE something1 IN (SELECT somefield2 FROM sometable2)
  AND something2 IN (SELECT somefield3 FROM sometable3)

score 1 · Answer 1 · answered Apr 22 '16 at 16:39

1

In a word - yes. You can have as many conditions as you want in a where clause, regardless of whether they have in conditions or not.

answered Apr 22 '16 at 16:39

Mureinik

297,002
52
306
350

Keep in mind one thing, however. While you can have as many conditions/sub-querys as possible, you can and will hit performance issues. – Leptonator Apr 22 '16 at 16:42
@Leptonator views dont affect the performances unless they are materialized which is not possible in most RDBMS – Thomas G Apr 22 '16 at 16:45
@ThomasG - have just removed my reference to views. – Leptonator Apr 22 '16 at 16:46

score 0 · Accepted Answer · answered Apr 22 '16 at 16:39

0

Yes. Your syntax needs to be fixed though:

SELECT somefield
FROM sometable
WHERE something1 IN (SELECT somefield2 FROM sometable2)                        
AND something2 IN (SELECT somefield3 FROM sometable3)

answered Apr 22 '16 at 16:39

Bohemian

412,405
93
575
722

Can you have more than one subquery in a where clause?

2 Answers2