连接查询的语句

reuental

我有2个表
查询表一的 reportname,path内容
要求，返回 reportname 不包含在 表二 reportname的列中，表二的列为username=xxx，
我无论用<>,not in都是取不到正确的结果
而，IN , = 可以取到相反要求的正确结果。。怎么搞啊

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

相反的都取到了，
那用not exists就能取到想要的了啊

wgfxman

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

reuental

多谢各位，原来需要多个()就可以解决啊。。我好笨。。试了半天