MERGE Wine.Producer AS CurrentData
SELECT DISTINCT ProducerID, ProducerName
) AS NewData
ON CurrentData.ProducerID = NewData.ProducerID
WHEN MATCHED THEN
CurrentData.ProducerName = NewData.
SQL Prompt fails to suggest any of the column names for the "NewData" object (or any other for that matter) after I enter the final period as shown in the extract. No error messages of any kind are generated.