Hoy, ik wil een insert on select uitvoeren op meerdere tabellen en met verschillende id's
Dit heb ik geprobeerd zonder success.
Code:
REPLACE INTO `category_to_store` AS cts
INNER JOIN `product_to_store` AS pts
INNER JOIN `information_to_store` AS its
INNER JOIN `manufacturer_to_store` AS mts
VALUES(cts.category_id, cts.store_id, pts.product_id, pts.store_id, its.information_id, its.store_id, mts.manufacturer_id, mts.store_id)
SELECT cts.category_id, pts.product_id, its.information_id, mts.manufacturer_id
ON cts.store_id = '2' AND pts.store_id = '2' AND its.store_id = '2' AND mts.store_id = '2'
WHERE cts.store_id = '0' AND pts.store_id = '0' AND its.store_id = '0' AND mts.store_id = '0'
en ook dit
Code:
REPLACE INTO `category_to_store` AS cts(cts.category_id, cts.store_id)
INNER JOIN `product_to_store` AS pts(pts.product_id, pts.store_id)
INNER JOIN `information_to_store` AS its(its.information_id, its.store_id)
INNER JOIN `manufacturer_to_store` AS mts(mts.manufacturer_id, mts.store_id)
SELECT cts.category_id, pts.product_id, its.information_id, mts.manufacturer_id
ON cts.store_id = '2' AND pts.store_id = '2' AND its.store_id = '2' AND mts.store_id = '2'
WHERE cts.store_id = '0' AND pts.store_id = '0' AND its.store_id = '0' AND mts.store_id = '0'
Is dit op een of andere manier te realliseren?
Groetjes,
Lenny
Favorieten/bladwijzers