这样试试:
declare @ta table(id int identity(1,1),pd_name varchar(10))
declare @tb table(id int identity(1,1),pd_name varchar(10))
insert @ta(pd_name)
select 'a' union all
select 'b' union all
select 'c' union all
select 'd' union all
select 'e'
insert @tb(pd_name)
select 'a' union all
select 'e'
select a.* from @ta a
full join @tb b
on a.pd_name = b.pd_name
where b.pd_name is null