UPDATE and DELETE statement understanding table alias
When creating an UPDATE or DELETE statement and referencing a table alias. It cannot understand these. For example:
UPDATE A
SET ID = 5
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.ID
SQLComplete does not understand the alias 'A' when writing the UPDATE or the SET statement.
3
votes
James
shared this idea