Quote Originally Posted by Aflatoon View Post
Please try:
"Select NW.[AssetID], S.[Alias], NW.[Role] from [ConfigurationData$N20:X76] NW, [ConfigurationData$B20:F27] S Where NW.[AssetID] = S.[AssetID]"
Same error. Here's the SQL after the conversion to make sure it matches.
"Select NW.[AssetID], S.[Alias], NW.[Role] from [ConfigurationData$N20:X76] NW, [ConfigurationData$B20:F27] S Where NW.[AssetID] = S.[AssetID]"