我加入了三张桌子：
SELECT
catalog_product_entity.entity_id AS product_id,
catalog_product_entity.sku,
customer_entity_varchar.entity_id AS customer_id,
customer_entity_varchar.value,
customer_entity_varchar.attribute_id,
import_tmp.customer,
import_tmp.grp,
import_tmp.qty,
import_tmp.price
FROM catalog_product_entity
INNER JOIN import_tmp
ON catalog_product_entity.sku = import_tmp.sku
INNER JOIN customer_entity_varchar
ON import_tmp.customer = customer_entity_varchar.value OR import_tmp.grp = customer_entity_varchar.value
WHERE customer_entity_varchar.attribute_id = 139 OR customer_entity_varchar.attribute_id = 140
目前，我正在获取数据，构建一个新的数组并将其插入到我的最终表中。
INSERT INTO final_table(`c_id`, `p_id`, `price`) VALUES (customer_id, product_id, price);
但是，我想知道是否可以一气呵成，所以基本上直接从临时表？
是的。使用插入。..选择:
INSERT INTO final_table (c_id, p_i`, price)
SELECT cev.entity_id AS customer_id,
cpe.entity_id AS product_id,
it.price
FROM catalog_product_entity cpe JOIN
import_tmp it
ON cpe.sku = it.sku JOIN
customer_entity_varchar cev
ON cev.value IN (it.customer, it.grp)
WHERE cev.attribute_id IN (139, 140);
注意，我引入了表别名。这使得查询更容易写入和读取。而且中的比重复的或条件更容易遵循。
INSERT INTO final_table(`c_id`, `p_id`, `price`)
SELECT
customer_entity_varchar.entity_id AS customer_id,
catalog_product_entity.entity_id AS product_id,
import_tmp.price
FROM catalog_product_entity
INNER JOIN import_tmp
ON catalog_product_entity.sku = import_tmp.sku
INNER JOIN customer_entity_varchar
ON import_tmp.customer = customer_entity_varchar.value OR import_tmp.grp = customer_entity_varchar.value
WHERE customer_entity_varchar.attribute_id = 139 OR customer_entity_varchar.attribute_id = 140
上面的代码可以做到这一点。只需选择要插入到final_table中的行。
