Database query with values from a table

[Anonymous]

Hi, 

newbie question - I'm trying to fetch a set of ID's from a table and use it when loading data from our SQL database - no luck so far. The where clause should include a set of ID's selected from a table (where "Include" = true). Help would be greatly appreciated.

[Anonymous]

Thanks!

[Anonymous · Accepted solution]

You've got to get the filter values into the same cell, like 123,456,457,897,etc. 

You can first transpose and then merge (combine) the columns and use a comma for the delimiter. Drill down on the one field, and then refer to your variable in the SQL, which you do have written correctly.

--Nate