About a month ago, I spent about a week figuring out how to get an SQL code to return all Store Codes associated with one Customer Number with no repeats. Below is the code that currently works on my offline backup.
"SELECT DISTINCT a.\"Store Code\"
FROM \"Ad Archives\" a
WHERE \"Customer #\" = ?" ;
" " ; "," ;
Fairly simple and straightforward (Now that I understand SQL a bit better!) However, when I move this SQL code over to my Cloud files, it simply outputs a "?". I made sure that the Store Code field is there and names properly, same with the Customer Number field and the Ad Archives table. What else could possibly be causing this issue that I'm not seeing?