Использование текущего значения столбца основного запроса в подзапросе

INSERT INTO DB1.dbo.PARTICIPANTS (PARTICIPANT_LASTNAME,PARTICIPANT_FIRSTNAME, 
PARTICIPANT_PATRONYMIC,PARTICIPANT_TYPE,PERMISSIONS,EMAIL,LOGIN_ID) 
SELECT S.L_NAME,S.F_NAME,S.M_NAME,S.TYPE,S.ADM,S.MAIL,
(SELECT L.ID FROM LOGINS L WHERE L.LOGIN=S.LOGIN) FROM DB2.PERSONS S

CREATE TABLE [dbo].[LOGINS](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [LOGIN] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_LOGINS] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
CREATE TABLE [dbo].[PARTICIPANTS](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [PARTICIPANT_LASTNAME] [VARCHAR](254) NOT NULL,
    [PARTICIPANT_FIRSTNAME] [VARCHAR](254) NOT NULL,
    [PARTICIPANT_PATRONYMIC] [VARCHAR](254) NOT NULL,
    [PARTICIPANT_TYPE] [VARCHAR](254) NOT NULL,
    [PERMISSIONS] [INT] NOT NULL,
    [LOGIN_ID] [INT] NULL,
    [EMAIL] [VARCHAR](50) NULL,
    [CONVOC] [VARCHAR](50) NULL,
 CONSTRAINT [PK_PARTICIPANTS] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = 
OBJECT_ID(N'[dbo].[FK_PARTICIPANTS_LOGINS]') AND parent_object_id = 
OBJECT_ID(N'[dbo].[PARTICIPANTS]'))
ALTER TABLE [dbo].[PARTICIPANTS]  WITH CHECK ADD  CONSTRAINT
 [FK_PARTICIPANTS_LOGINS] FOREIGN KEY([LOGIN_ID])
REFERENCES [dbo].[LOGINS] ([ID])

CREATE TABLE [dbo].[PERSONS](
    [ID] [INT] NOT NULL,
    [DISABLED] [VARCHAR](1) NULL,
    [TARGET_DOCSRVR] [INT] NULL,
    [LAST_UPDATE] [datetime] NULL,
    [L_NAME] [VARCHAR](50) NULL,
    [F_NAME] [VARCHAR](50) NULL,
    [M_NAME] [VARCHAR](50) NULL,
    [MAIL] [VARCHAR](50) NULL,
    [LOGIN] [VARCHAR](20) NULL,
    [ADM] [INT] NULL,
    [TYPE] [tinyint] NULL,
 CONSTRAINT [PK_PERSONS] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]