SQL Query Error

garretwalters12

Why when using SQL query I receive an error for the below, and why do I receive red quotations around "US"? The query works without the WHERE clause and the value US does exist in the country field. Does Alteryx SQL query just not support the WHERE clause? or am I just forced to use the other In-Database tools?

Select *

From table_name

WHERE country = "US"

Christine_Assaad

Hi @garretwalters12 

Would you please try to add table name in front of the column like in the below example?

select *
from Customer
where Customer.country = 'US'