mistake in the syntax inner join

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

Somebody knows what is below wrong in my syntax. Because when I try to
generate he/she gives mistake in the syntax inner join. It was worth thank
you very much.

Update [Cadastro de formulário] INNER JOIN [Formularios] ON [Cadastro de
formulário].[Código formulário] = [Formularios].[Código formulário] SET
[Formularios].[Descricao] = [Descrição]
 
Somebody knows what is below wrong in my syntax. Because when I try to
generate he/she gives mistake in the syntax inner join. It was worth thank
you very much.

Update [Cadastro de formulário] INNER JOIN [Formularios] ON [Cadastro de
formulário].[Código formulário] = [Formularios].[Código formulário] SET
[Formularios].[Descricao] = [Descrição]
Click to expand...

Looks correct to me! The only question would be: is [Código
formulário] in [Cadastro de formulário] of the same datatype and size
as the field in [Formularios]? And have you defined a Relationship
between the two tables using this field (this should not be necessary,
however!)
 
Back
Top