求助，表格问题2

create view 材料进出
as
select
    isnull(a.材料名称, b.材料名称) as 材料名称,
    isnull(a.入库数量, 0) as 入库数量,
    isnull(a.入库金额, 0) as 入库金额,
    isnull(b.发货数量, 0) as 出库数量,
    isnull(b.发货金额, 0) as 出库金额
from
    入库表 as a full join 发货表 as b on a.材料名称 = b.材料名称
go

select * from 材料进出