create or replace view view_indexTemplate as select a. *, b.content_bewrite, c.label_dm, c.label_content from bjlife_document_file b, (select e.label_dm, e.label_content, f.doc_dm from bjlife_template_label e, bjlife_document_label f where e.label_dm = F.Label_dm) c, bjlife_document a where a.doc_dm = B.doc_dm and c.doc_dm = B.DOC_DM and A.DOC_DM = C.DOC_DM and A.YN_FirstPage = '1' and a.yn_publish = '1' and yn_audit = '1'
