How to use a WHERE clause in a query to csv file


I am using a csv file as a datasource. First I created a datasource as CSV (from URL) to retrieve the csv file. Then I created a second datasource as a QUERY RESULTS. I created a new query and chose the QUERY RESULTS datasource In the csv file I have 2 columns, labelled a and b. I would like to find the value in column a for a particular value in column b. The syntax I have tried is:

SELECT a where b=123456
FROM query_154607

The error I get is:
Error running query: near “from”: syntax error

Both column a and b are numbers.

Any suggestions? Thanks


Did you mean SELECT a
FROM query_154607
where b=123456?