HOW MAKE A update WITH left join DOCTRINE

Question

i want to do this in doctrine symonfy2

 update producto p
 left join producto_compra pc ON p.id = pc.id_producto
 set p.cantidad = (p.cantidad - pc.cantidad)
 where pc.id_compra = '56';

and i tried with this, and it doesnt work

$em = $this->getEntityManager();

 $query = $em->createQuery('UPDATE ORM\Entity\Producto p '
 . 'LEFT JOIN ORM\Entity\ProductoCompra pc WITH p.id = pc.idProducto '
 . 'SET p.cantidad = (p.cantidad - pc.cantidad) '
 . 'WHERE pc.idCompra = :fc ')
 ->setParameter('fc', $facturacompra);

score 2 · Accepted Answer · answered Sep 11 '17 at 06:02

2

similar question look at here, i see that join is not supported in update or delete queries.

answered Sep 11 '17 at 06:02

T. Abdelmalek

418
3
10

HOW MAKE A update WITH left join DOCTRINE

1 Answers1