Sam,

The SQL() function can can only work with ONE return value.

If the view contains more than one column the "SELECT *" needs to be something like "SELECT CUSTOMERNUMBER"
If the WHERE clause returns more than one value it needs to be changed in a way to return the value of one row only.

You most likely better use a SQL statement as data-source.