Hi,
I'm trying to use a vey simple WHERE statement in my SQL query but I keep getting an error saying could not resolve column. You documentation seems to suggest what I'm trying to do is possible so I'm a bit lost.
I'm trying to do:
SELECT
*
FROM miseq_results
WHERE well = "A01"
and I get this error:
Query 'lists_temp_5991' has errors Edit Query
Error on line 5: Could not resolve column: A01 edit lists_temp_5991
and your documentation says that it should be possible to use where to filter on a value, rather than column=column:
Filter the results for certain values. Example:
SELECT *
FROM "Physical Exam"
WHERE YEAR(Date) = 2010
Could someone help me with where I'm going wrong please?
Katy