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"

[mrbillyjackson]

Have you tried single quotes?

[christine_assaad]

Hello @mrbillyjackson 

Please try 'US' instead of "US". Alteryx supports Where clauses, no problem. Hope it helps. Cheers!

[garretwalters12]

yes, I receive the same errors?

[christine_assaad · Accepted solution]

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'