不要這樣下,改這樣:
select
INVMC.MC001 as 品號,
INVMC.MC002 as 主要庫別,
INVMC.MC004 as 安全庫存量
from INVMC
left join bcd ON INVMC.MC001=bcd.MC001 and INVMC.MC002=bcd.MC002
改成
select MC001 as 品號,
MC002 as 主要庫別,
MC004 as 安全庫存量
from INVMC, bcd
where IMVMC.MC001=bcd.MC001 and IMVMC.MC002=bcd.MC002
試看看