Multipart identifier could not be bound

ashob athoillah

Question

so i get error multipart identifier "table name" could not be bound

here my query.

SyntaxEditor Code Snippet

INSERT INTO {Submited}({Submited}.[Hardener]) VALUES({DataHardener}.[Hardener])

25 Oct 2018

Eduardo Jauch

Hello ashob

Yes.
This is because {DataHardener} is not present in any subquery, so it is unknown to database server in this statement.

Why don't you use the CreateSubmited entity action to create a new record in this entity, instead of using SQL?

Cheers.

25 Oct 2018

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.