if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gwfw_indo]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v_gwfw_indo]
GO
CREATE VIEW dbo.v_gwfw_indo
AS
SELECT dbo.gwfw_wj.jjcd, dbo.gwfw_wj.wjlx, dbo.gwfw_wj.gwbt, dbo.gwfw_cl.followid,
dbo.gwfw_cl.clsj, dbo.gwfw_cl.userid, dbo.gwfw_cl.wjzt, dbo.gwfw_cl.fileid,
dbo.gwfw_cl.clyj
FROM dbo.gwfw_wj INNER JOIN
dbo.gwfw_cl ON dbo.gwfw_wj.fileid = dbo.gwfw_cl.fileid
WHERE (dbo.gwfw_cl.clqk = '完')
GO