Update precios

[Libras]

Código SQL:

UPDATE ges_articulos 
SET ultimo_costo=albcompra.base_linea 
FROM ges_articulos AS t1 
INNER JOIN (SELECT articulo, base_linea FROM ges_albcompra_lin GROUP BY articulo,base_linea) AS albcompra
ON t1.cref = albcompra.articulo