sql 小例子

create table testtable1
(
id int IDENTITY,
department varchar(12) 
)
select * from testtable1
insert into testtable1 values('设计')
insert into testtable1 values('市场')
insert into testtable1 values('售后')

create table testtable2
(
id int IDENTITY,
dptID int,
name varchar(12)
)
insert into testtable2 values(1,'张三')
insert into testtable2 values(1,'李四')
insert into testtable2 values(2,'王五')
insert into testtable2 values(3,'彭六')
insert into testtable2 values(4,'陈七')

SELECT [testtable2].* , ISNULL(department,'没有')
FROM[testtable1] 
right join [testtable2] 
on [testtable2].dptID = [testtable1].ID 
order by [testtable2].id desc