Join query statement

reuental

I have 2 tables
Queryname, reportname, path content
Requirement, return reportname is not included in the column of reportname in Table 2. The column in Table 2 is username = xxx.
No matter I use <>, not in will not get the correct result
However, IN, = can get the correct result required to the contrary. . How to do it

SELECT dbo.ReportList. *
FROM dbo.ReportList INNER JOIN
      dbo.UserReport ON dbo.ReportList.ReportName <> dbo.UserReport.ReportName

我是杀人狂

SELECT dbo.ReportList. *
FROM dbo.ReportList a,
      dbo.UserReport b where a.ReportName <> b.ReportName

cv4bf5d65fd

select reportname, path from ReportList where reportname not in (select reportname from UserReport)

dream88

SELECT dbo.ReportList. *
FROM dbo.ReportList a,
      dbo.UserReport b where isnull (a.ReportName, '') <> isnull (b.ReportName, '')

gaoqingfeng

select * from ReportList a where not exists (select * from UserReport where ReportName = a.ReportName)

fanfan1980

--try

SELECT dbo.ReportList. *
FROM dbo.ReportList as A
where exists (select 1 from UserReport where ReportName <> A.ReportName)

seaeva

The opposite is obtained,
Then you can get what you want with not exists

wgfxman

SELECT dbo.ReportList. *
FROM dbo.ReportList as A
where A.ReportName NOT IN (select ReportName from UserReport)

reuental

Thank you all. It turns out that you need multiple () to solve it. . I'm so stupid. . Tried for a long time