I receive an error that the maximum prefix is 3 when I try to execute the query below
SELECT nssql.SalesOfficeID, nssql.Name
FROM NSSQL.MyDatatabse.com.SPLive.NSSQL.dbo.SalesOffices AS nssql
I am trying to use the alias method to work around the prefix limitation. I didn't add the AS statement, Can someone tell me what I am doing wrong?