WHERE Clause condition from cvs file
Answered
Hello
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
Please sign in to leave a 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.