Fresbee Wabi Pets

Información del producto

SELECT c.*, c.fecha_emision AS Fecha, c.campo2 AS vuelto, l.codigo_clte AS codigo_cliente, l.codigo_clte AS codigo_clte, t.descripcion_categ AS categoria, p.codigo_termino AS codigo_termino, p.Descripcion_termino as Descripcion_termino, v.Codigo_vendedor, v.Nombre_vendedor, v.Nombre_vendedor AS vendedor, ISNULL(v.Direccion3, ) AS telefono_vendedor, ISNULL(g.giro_negocio, ) AS dsc_rubro, ISNULL(l.contacto, ) AS contacto, ISNULL(l.telefono1, ) AS telefono1, ISNULL(l.telefono2, ) AS telefono2, ISNULL(l.e_mail1, ) AS email1, ISNULL(l.e_mail2, ) AS email2, ISNULL(l.campo1, ) As campo1, ISNULL(l.campo2, ) As campo2, ISNULL(l.campo3, ) As campo3B, ISNULL(l.campo2, ) As digver, ISNULL(l.ciudad, ) As c_ciudad, ISNULL(l.provincia, ) as c_provincia, ISNULL(l.pais, ) as c_pais FROM factura c LEFT JOIN clientes l ON c.cliente_id = l.cliente_id LEFT JOIN terminos_pago p ON c.termino_id = p.termino_id LEFT JOIN vendedores v ON c.vendedor_id = v.vendedor_id LEFT JOIN Categorias_clte t ON l.Categoria_Clte_id = t.categoria_clte_id LEFT JOIN giro_negocios g ON l.giro_id = g.giro_id WHERE c.nro_factura = ?wNroDocAct