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"
Solved! Go to Solution.
Have you tried single quotes?
Hello @mrbillyjackson
Please try 'US' instead of "US". Alteryx supports Where clauses, no problem. Hope it helps. Cheers!
yes, I receive the same errors?
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'