Query in sql

Any other help me

Same replay and not working 

It seems that the issue with the query is in the WHERE clause. Specifically, the conditions for ClaimType and ClaimValue are both being applied to the same row in the AspNetUserClaims table, which cannot be true since the same row cannot have two different values for the ClaimType column. Therefore, the query is returning no results.

To fix this, you should change the WHERE clause to use the OR operator instead of AND, so that it will match rows that have either of the two conditions. Here's the corrected query:

sql:

SELECT *
FROM auth.AspNetUsers
JOIN Auth.AspNetUserClaims ON auth.AspNetUserClaims.UserId = auth.AspNetUsers.Id
WHERE 
(auth.AspNetUserClaims.ClaimType = 'TrialEndOn' AND CONVERT(varchar(10), auth.AspNetUserClaims.ClaimValue,111) > CONVERT(varchar(100),GETDATE(),120))
OR 
(auth.AspNetUserClaims.ClaimType = 'TrialStatus' AND auth.AspNetUserClaims.ClaimValue = 'inactive')

the query should correctly join the two tables and return the expected results.

I have changed not working

select * from auth.AspNetUsers
  Join Auth.AspNetUserClaims ON auth.AspNetUserClaims.UserId=auth.AspNetUsers.Id
Where (auth.AspNetUserClaims.ClaimType='TrialEndOn' AND CONVERT(varchar(10), auth.AspNetUserClaims.ClaimValue,111) > CONVERT(varchar(100),GETDATE(),120))
AND (auth.AspNetUserClaims.ClaimType='TrialStatus' AND auth.AspNetUserClaims.ClaimValue='inactive')

It looks like the second query you provided is the same as the first one, with one small difference in the syntax: the table alias used for the AspNetUsers table is different (Auth instead of Au). This could be the reason why the second query is not returning any results, because it's not correctly joining the two tables.

To fix this, you should make sure to use the same table alias (Au) for both tables in the query. Here's the corrected query:

sql code: 

select * from au.AspNetUsers
  Join Au.AspNetUserClaims ON Au.AspNetUserClaims.UserId=au.AspNetUsers.Id
Where (Au.AspNetUserClaims.ClaimType='TrialEndOn' AND CONVERT(varchar(10), Au.AspNetUserClaims.ClaimValue,111) > CONVERT(varchar(100),GETDATE(),120))
AND (Au.AspNetUserClaims.ClaimType='TrialStatus' AND Au.AspNetUserClaims.ClaimValue='inactive')
 

With this change, the query should correctly join the two tables and return the expected results.