let´s say I have a column with 10 unique ISINs in Excel. I want to pass these ISINs as argument/parameter to query. I know it works with a single cell, where I put "?" in the query and the cell as parameter, but it doesn´t work with multiple cells. I want to filter the SELECT statement with WHERE clause, where it returns only the rows with these ISINs. Something like this:
SELECT e.ISINCode 'ISIN',
e.Equities_ShortName 'ShortName',
e.Equities_Name 'LongName',
FROM Equities e,
AND e.ISINCode In (?)
Is it even possible to do it? We use Sybase SQL, or iSQL, I´m not too familiar with these databases, I just know a little bit of SQL coding. Thank you