DELETE FROM [DatabaseName].[dbo].[Sessions]
WHERE [DatabaseName].[dbo].[Users].[Id] = [DatabaseName].[dbo].[Users].[Ud]
GO
DELETE FROM Sessions AS S
WHERE Users.Id = Users.Username
DELETE FROM [DatabaseName].[dbo].[Sessions] as S
INNER JOIN [DatabaseName].[dbo].[Users] as U on S.UserId = U.Id
WHERE U.Id = U.Username
GO
delete from sessions s where S.userid in (select id from users u, sessions ss where ss.userid = u.id and u.username = 'Guid')
DELETE S FROM [DatabaseName].[dbo].[Sessions] as S
INNER JOIN [DatabaseName].[dbo].[Users] as U on S.UserId = U.Id
WHERE U.Id = U.Username
GO
Open in new window
Would you mind giving out more details about what you are trying to do ?
Thank you.