一个视图的写法

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'