Modificar campos de tablas usando una consulta
Publicado por findpops.com (1 intervención) el 17/05/2017 12:49:52
Buenas, estoy intentando modificar los campos de una tabla en base a una consulta que ya tengo:
He metido este comando pero me da error:
1
2
3
4
5
6
7
8
9
10
11
SELECT `fpop_product`.`id_product` AS `id_product`,
`fpop_product`.`reference` AS `reference`,
`fpop_product_lang`.`name` AS `name`,
`fpop_image_shop`.`id_image` AS `id_image`,
`fpop_image_lang`.`legend` AS `alt`FROM `fpop_product`
LEFT JOIN `fpop_product_lang` ON (`fpop_product_lang`.`id_product` = `fpop_product`.`id_product` AND `fpop_product_lang`.`id_lang` = 3 AND `fpop_product_lang`.`id_shop` = 1)
LEFT JOIN `fpop_image_shop` ON (`fpop_image_shop`.`id_product` = `fpop_product`.`id_product` AND `fpop_image_shop`.`cover` = 1 AND `fpop_image_shop`.id_shop = 1)
LEFT JOIN `fpop_image_lang` ON (`fpop_image_lang`.`id_image` = `fpop_image_shop`.`id_image` AND `fpop_image_lang`.`id_lang` = 3)
LEFT JOIN `fpop_image` ON (`fpop_image`.`id_image` = `fpop_image_shop`.`id_image`)
WHERE 1
He metido este comando pero me da error:
1
2
3
4
5
6
7
8
9
10
11
UPDATE `fpop_image_lang` SET `legend`=`fpop_product_lang`.`name` WHERE repclie IN(SELECT `fpop_product`.`id_product` AS `id_product`,
`fpop_product`.`reference` AS `reference`,
`fpop_product_lang`.`name` AS `name`,
`fpop_image_shop`.`id_image` AS `id_image`,
`fpop_image_lang`.`legend` AS `alt`FROM `fpop_product`
LEFT JOIN `fpop_product_lang` ON (`fpop_product_lang`.`id_product` = `fpop_product`.`id_product` AND `fpop_product_lang`.`id_lang` = 3 AND `fpop_product_lang`.`id_shop` = 1)
LEFT JOIN `fpop_image_shop` ON (`fpop_image_shop`.`id_product` = `fpop_product`.`id_product` AND `fpop_image_shop`.`cover` = 1 AND `fpop_image_shop`.id_shop = 1)
LEFT JOIN `fpop_image_lang` ON (`fpop_image_lang`.`id_image` = `fpop_image_shop`.`id_image` AND `fpop_image_lang`.`id_lang` = 3)
LEFT JOIN `fpop_image` ON (`fpop_image`.`id_image` = `fpop_image_shop`.`id_image`)
WHERE 1);Valora esta pregunta
0
