Excel SQL Extract

[400092]

I am trying to extract data for specific list of identifers (around 30). How can I list them in sql query in where clause?

 

[Fazza]

in a where clause and numeric using WHERE fieldname IN (123, 234, 345)
in a where clause and text using WHERE fieldname IN ('alpha', 'beta', 'gamma')

or if including the specific list is in a table, you can refer to the table & not list them individually in the WHERE clause
SELECT fields
FROM maintable M, filterlist F
WHERE M.commonfield = F.commonfield

Or without a WHERE clause using a join
SELECT fields
FROM maintable M INNER JOIN filterlist F ON m.commonfield = F.commonfield

HTH