从多个选择中插入MS Access 2013 c#错误

本文关键字：Access 2013 错误 MS 插入选择 | 更新日期: 2023-09-27 17:50:44

我在查询中有一个错误，我试过这个:

INSERT INTO Manuacturer_Item (item_id, manufacturer_id) 
SELECT      i.id, 
            m.id 
FROM        Item AS i 
CROSS JOIN  Manufacturer AS m 
WHERE       i.iname LIKE 'PC' AND m.mname LIKE'zaz'

我错过了什么?

在Access SQL中可以是:

INSERT INTO Manuacturer_Item 
    (item_id, manufacturer_id) 
SELECT  
    i.id, m.id 
FROM 
    [Item] AS i,
    Manufacturer AS m 
WHERE   
    i.iname like 'PC' AND m.mname like 'zaz'