DROP VIEW VW_ARTICULOS
GO
CREATE VIEW VW_ARTICULOS
AS
SELECT I.CLASSID AS CDCATE,C.DESCR AS DSCATE,I.CLASSUBID AS CDSCAT,S.DESCR AS DSSCAT,
I.INVTIDSKU AS CDARTICULO,I.DESCR AS DSARTICULO 
FROM (IN_INVENTORY AS I JOIN IN_CATEGORY AS C
ON I.CLASSID=C.CLASSID) JOIN IN_SUBCATEGORY AS S
ON I.CLASSUBID=S.CLASSUBID

