Folks, I need somebody's help to understand the mistake you're making. I have two tables as shown in the code, and in one of the tables the "CodePlane" column has information. I need to put the codes related to the Beneficiaries. But it is giving the error:
Syntax "Incorrect Syntax near the keyword 'FROM'"
SELECT [SemPlano].[NomeBenefTitular] AS [BenfTitularS],
[ComPlano].[NomeBenefTitular] AS [BenfTitularC],
[SemPlano].[NomeUsuario] AS [NomeUsuarioS],
[ComPlano].[NomeUsuario] AS [NomeUsuarioC],
[SemPlano].[CodigoPlano] AS [CodPlanoS],
[ComPlano].[CodigoPlano] AS [CodPlanoC],
FROM [TabelaUm] AS [SemPlano]
INNER JOIN [TabelaDois] AS [ComPlano] ON [BenfTitularS] = [BenfTitularC]