Forum Discussion
Database query with values from a table
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...
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
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