sql - Combine "delete query" -

i'm making stored procedure query doesn't work.

create proc deleteuser      @username varchar(50)          begin     declare @sql nvarchar(max) = 'delete lars.userinformation username='+@username;     'delete lars.useracces username='+@username     exec sp_executesql @sql,n'     @username     ',@username     end 

how without using joins?

you don't need dynamic sql:

create proc deleteuser     @username varchar(50)  begin     delete lars.userinformation username=@username;     delete lars.useracces username=@username; end