Вытащить Id с второй таблицы и передать его в первую

ALTER PROCEDURE [dbo].[AddBook]
    (
        @bookName nvarchar(20),
        @authorID int,
        @genreID int,
        @amountPages int,
        @isdn int,
        @userID nvarchar(20),
        @addedDate datetime
    )
    
AS
SELECT Users.Id FROM Users WHERE Login = @userID;
INSERT INTO Books (BookName, AuthorID, GenreID, AmountPages, ISDN, UserID, AddedDate)
VALUES (@img, @bookName, @authorID, @genreID, @amountPages, @isdn, @userID, @addedDate)
RETURN

ALTER PROCEDURE [dbo].[AddBook]
    (
        @bookName nvarchar(20),
        @authorID int,
        @genreID int,
        @amountPages int,
        @isdn int,
        @user nvarchar(20),
        @addedDate datetime
    )
    
AS begin
declare @userID int
SELECT @userID = Users.Id FROM Users WHERE Login = @user;
INSERT INTO Books (BookName, AuthorID, GenreID, AmountPages, ISDN, AddedDate, UserAddedID)
VALUES (@bookName, @authorID, @genreID, @amountPages, @isdn, @addedDate, @userID)
RETURN
end