IF EXISTS (SELECT * FROM sysobjects WHERE ID=OBJECT_ID(N'vz_job_total_mt'))
DROP VIEW vz_job_total_mt
GO

CREATE VIEW vz_job_total_mt
AS
SELECT
a.*,
b.iporder"iporder_p",
b.cprosid"cprosid_p",
b.dfinidt"dfinidt_p"
FROM vz_JOB_PROD a,job_prosdt b
WHERE a.ccode=b.ccode AND B.CPROSID<>'03' AND
GO