Codigo de la Consulta
CREATE PROCEDURE pa_VNV @xxx INT
AS
SELECT nv.nu,
nv.us,
nv.in,
nv.fe,
nv.cl,
oc.in AS [oin],
oc.cma,
oc.cmo,
oc.cve,
oc.cco,
oc.ven,
ma.cod,
ma.nom AS [manom],
mo.nom AS [mnom],
ve.nom AS [venom],
co.nom AS [conom]
FROM ntv AS nv
INNER JOIN oco AS oc
ON nv.int=oc.int AND
nv.int=oc.int
INNER JOIN mar AS ma
ON oc.cmar=ma.cod AND
nv.int=oc.int
INNER JOIN mod AS mo
ON oc.cmo=mo.cmo AND
nv.int=oc.int
INNER JOIN ver AS ve
ON oc.cver=ve.cver AND
nv.int=oc.int
INNER JOIN col AS co
ON oc.cco=co.cod
{Aqui va el codigo que me indicaron
pero persiste el error
Gracias}
WHERE nv.usu=@xxx and nv.est=0
ORDER BY numero
GO
__________________
Los muertos en CRISTO de sus tumbas volveran y los que vivimos en las nubes nos levantara .......
|