[請教]create view的問題

[hungnung]

我想建立一個view，好讓我在excel vba中執行select 但一直無法建立，請各位高手大大們教教我

這是我的access sql指令:

SELECT BOM_02.MD001, NZ(BOM_02_1.MD003,BOM_02.MD003) AS MD003, NZ(BOM_02_1.MB002,BOM_02.MB002) AS MB002
FROM BOM_02 LEFT JOIN BOM_02 AS BOM_02_1 ON BOM_02.MD003 = BOM_02_1.MD001
ORDER BY 1, 2, 3;

謝謝