Precios y códigos de barras

SELECT [02] AS "Mayor SIN IVA",A.CODIGO AS Codigo, B.BARRAS AS Codigo_barras, A.NOMBRE AS Nombre, A.ABREV AS Codigo_alternativo, A.UBICACION AS Localizacion, CAST(A.NOMBRE2 AS CHAR(250)) AS Ampliacion_definicion, (CASE WHEN A.TIPO_ART = 1 THEN 'Ventas y Compras' ELSE (CASE WHEN A.TIPO_ART = 2 THEN 'Ventas' ELSE 'Compras' END) END) AS Tipo_articulo

FROM GESTION!ARTICULO A

LEFT JOIN GESTION!BARRAS B ON A.CODIGO = B.ARTICULO

left JOIN (
select * from
(
 select ARTICULO,TARIFA,PVP from GESTION!PVP PV
) b
pivot (max(PVP) for [TARIFA] in ([02])) PV2
) PV ON a.codigo = PV.ARTICULO
WHERE A.TIPO = 1 AND B.TALLAERP = '' AND B.COLORERP = ''