表A(key,v1),表B(key,v2)，其中连接的公共字段key。假设A为左表，在MySQL语言中能实现如图涂色部分查询的是（ ）

key is null是右反连接。key is null是左反连接，

A.        select * from A full join B using(key);

B.        select * from A left join B using(key)union select * from B right join B using(key);

C.        select * from A left join B on A.key=B.key where B.key is null union select * from A right join B on A.key=B.key where A.key is null;

D.        select * from A left join B using(key)union all select * from B right join B using(key);

题目来源于CDA模拟题库

点击此处获取答案