SQL：查询不在此部门和未分配部门的人员

[huaier200]

SELECT 
	  Users.[uID]
	  ,[uName]
	  ,[uAccount]
	  ,[uPWD]
	  ,[uCreationDate]
	  ,[uJoinDate]
	  ,[uAddress]
	  ,[uTel]
	  ,[uEmail]
	  ,[uSN]
	  ,[uStatus]
	  ,[uSex]
	  ,[uBirthday]
	  ,[uContact]
	  ,[uContactTel]
	  ,[uIsAppUser]
	  ,[uIsAdmin] 
	FROM Users 
	LEFT JOIN User_Department ON User_Department.uID=Users.uID
where dID<>1

表Users：

CREATE TABLE [dbo].[Users](
	[uID] [int] IDENTITY(1,1) NOT NULL,
	[uName] [varchar](50) NOT NULL,
	[uAccount] [varchar](50) NOT NULL,
	[uPWD] [varchar](50) NOT NULL,
	[uCreationDate] [datetime] NULL,
	[uJoinDate] [datetime] NULL,
	[uAddress] [varchar](200) NULL,
	[uTel] [varchar](50) NULL,
	[uEmail] [varchar](100) NULL,
	[uSN] [varchar](50) NULL,
	[uStatus] [int] NULL CONSTRAINT [DF__Users__uStatus__22AA2996]  DEFAULT ((1)),
	[uSex] [int] NULL CONSTRAINT [DF__Users__uSex__239E4DCF]  DEFAULT ((0)),
	[uBirthday] [datetime] NULL,
	[uContact] [varchar](50) NULL,
	[uContactTel] [varchar](50) NULL,
	[uIsAppUser] [int] NULL CONSTRAINT [DF__Users__uIsAppUse__24927208]  DEFAULT ((0)),
	[uIsAdmin] [int] NULL CONSTRAINT [DF__Users__uIsAdmin__25869641]  DEFAULT ((0)),

表User_Department：

CREATE TABLE [dbo].[User_Department](
	[udID] [int] IDENTITY(1,1) NOT NULL,
	[dID] [int] NOT NULL,
	[uID] [int] NOT NULL,
	[udCreationDate] [datetime] NULL,
         

[fhpu168]

where 1=1

User_Department.dID is not null

and User_Department.dID !='1'

[huaier200]

已经有了解决办法 ：
where ISNULL(dID,-1)<>1

[肖恩]

LZ好快的速度！！