What happened to my IF / ELSE? "ELSE: Incorrect syntax next to" ELSE "."

IF - Else

syntax

If condition
begin
--statement
end
else 
begin
--statement
end

      

        
        
        
      

    

In your request, after the first one, IF statement

you will group the operators Begin - End

, they should all be wrapped inside Begin - End

. how

IF ((SELECT COUNT(*) FROM [main-table] WHERE [identification-number] = @IdentificationNumber) > 0)
Begin -- Missing
    SET @Foreign_ID = (SELECT [Foreign_ID] FROM [main-table] WHERE [identification-number] = @IdentificationNumber) 

    BEGIN
        UPDATE [main-table]
        SET [column1] = '', [column2] = '', [column3] = ''
        WHERE [Foreign_ID] = @Foreign_ID
    END

    BEGIN
        UPDATE [table2]
        SET [column4] = '', [column5] = '', [column6] = ''
        WHERE [Foreign_ID] = @Foreign_ID
    END

    BEGIN
        UPDATE [table3] 
        SET [column7] = '', [column8] = '', [column9] = ''
        WHERE [Foreign_ID] = @Foreign_ID
    END
END -- Missing
else
....