" insert into select " 在科尔马查询

Question

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers; 

客户

表还有其他列，除了"客户名称"和"国家/地区"之外

这是我的简单 sql 查询。

请帮助我用KORMA SQL编写它。

Answer 1

你可以和sql几乎一样

：

; assuming that you already define entities, customer, suppliers
(insert customers
  (values (select suppliers
                  (fields :suppliername :country))))