遗憾: Access 没有 full join
如下方案替代:
SQL 语句:
(SELECT Notebook.商品号, Notebook.描述, Inventory.库存
FROM Inventory right JOIN Notebook ON Inventory.商品号 = Notebook.商品号)
union
(SELECT Inventory.商品号, Inventory.描述, Inventory.库存
FROM Inventory left JOIN Notebook ON Inventory.商品号 = Notebook.商品号);
查询结果: