I am trying to create a view that will look in 2 tables and if records are not in the other table then it will show those records.
SELECT dbo.AspNetUsers.Id, dbo.AspNetUsers.Email, dbo.AspNetUsers.UserName
FROM dbo.AspNetUsers INNER JOIN
dbo.AspNetUserRoles ON dbo.AspNetUsers.Id <> dbo.AspNetUserRoles.UserId
here is the query but when I execute it shows duplicates if the ID is not in dbo.AspNetUsers table. dont know if, what i am doing is correct or maybe somehting else needs to happen? hope to get some help.
SELECT dbo.AspNetUsers.Id, dbo.AspNetUsers.Email, dbo.AspNetUsers.UserName
FROM dbo.AspNetUsers INNER JOIN
dbo.AspNetUserRoles ON dbo.AspNetUsers.Id <> dbo.AspNetUserRoles.UserId
here is the query but when I execute it shows duplicates if the ID is not in dbo.AspNetUsers table. dont know if, what i am doing is correct or maybe somehting else needs to happen? hope to get some help.