DROP VIEW VW_TURNOS_VENDEDOR
GO 
CREATE VIEW VW_TURNOS_VENDEDOR 
AS
SELECT OP_TURNVSSIDE.SALESPERID,SALESPERNAME,OP_TURNVSSIDE.SIDE as Cara,HOSENUMBER as Manguera,INVTIDBARR,OP_SIDE_FUEL.Descr as Articulo,OP_TURNVSSIDE.SITEID,DATEPROCE,DATESALES,NUMBERTURN,STATUS
FROM (OP_TURNVSSIDE JOIN OP_SIDE_FUEL
ON OP_TURNVSSIDE.SIDE=OP_SIDE_FUEL.SIDE) JOIN OP_SALESPERSON
ON OP_TURNVSSIDE.SALESPERID=OP_SALESPERSON.SALESPERID


