请教两表的查询结果

[freescy2002]

有二张表如下A和B,A表中的a字段需要跟B表中的d查找不存在的并且显示出来，谢谢大家帮助。
A表
uid a
1 1
1 2
1 3
2 1

B表
d
1
2
3
4
最后查询结果要如下
uid a
1 4
2 2
2 3
2 4

[二月十六]

--测试数据
if not object_id(N'Tempdb..#A') is null
	drop table #A
Go
Create table #A([uid] int,[a] int)
Insert #A
select 1,1 union all
select 1,2 union all
select 1,3 union all
select 2,1
GO
if not object_id(N'Tempdb..#B') is null
	drop table #B
Go
Create table #B([d] int)
Insert #B
select 1 union all
select 2 union all
select 3 union all
select 4
Go
--测试数据结束
SELECT t1.uid ,d AS a FROM (
SELECT * FROM #B CROSS APPLY (SELECT DISTINCT uid FROM #A)t
)t1 LEFT JOIN #A ON d=a AND #A.uid = t1.uid WHERE a IS NULL

[freescy2002]

谢谢大版，感谢