How to use SQL query with a column of values for where?

Question

How can I loop though a column of IDs I created with in a 2nd select query with a WHERE.

Example table of ids to loop through:

Here is what I got so far:

WITH myTable  
AS (  
    select myKey as myKey  
    from dbo.table  
    Where column2 = 'x'  
    GROUP BY myKey  
)  
SELECT *  
FROM table2  
WHERE table2.key = myKey

I can't loop through table2 with my column of values. How can I do it?

Why do you want to "loop" at all? SQL is a set based language so looping is one of the last things you want to actually do. When writing SQL you want to implement set based operations, not iterative ones — Thom A
– Thom A ♦, Commented Nov 30, 2020 at 16:37

Gordon Linoff · Accepted Answer · 2020-11-30 16:32:10Z

1

You can use in:

SELECT *
FROM table2
WHERE table2.key IN (SELECT mt.myKey FROM myTable mt);

Given that the mykey is unique, you can also use JOIN and EXISTS.

answered Nov 30, 2020 at 16:32

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use SQL query with a column of values for where?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related