WHERE Clause condition from cvs file


I have a situation where I need to get additional information about items in the database. 
I will get a list of items from a csv file and that list could be the WHERE clause.
I cannot import that data into a temporary table since I only have read rights on the database. 

Is there a way to do this? 
The list could get rather long, maybe 50 to 200 lines

1 comment

Hello Sacha,

There is no way to import a CSV file and use it as WHERE clause.

However, you can use WHERE filter in the query results.


Please sign in to leave a comment.