sqlserver建视图

在sqlserver中新建视图，合并多个表的数据。

drop view applns
go
create view dbo.applns
  AS  
 select Record_ID,  appln_filing_date, APPLN_AUTH, CITED_PAT_CO, CLAIM_CO, PAT_FAMILY_SIZE, IMAGE_REFS,INT_PHASE,REG_PHASE, nat_PHASE , appln_applicant_nametotal, appln_inventor_nametotal, publn_date, ipc_class_symbol, cpc_class_symbol, uspc_class_symbol,jpc_class_jppc,locar_class_symbol, CITATION_APPLN_ID, CITATION_LIT_CONT   from dbo.TLS1_APPLN t1
LEFT JOIN TLS8_APPLN_APPLICANT t2 on t2.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS9_APPLN_inventor t3 on t3.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS10_APPLN_AGENT t4 on t4.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS12_PAT_PUBLN t5 on t5.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS17_APPLN_IPC t6 on t6.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS18_APPLN_CPC t7 on t7.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS19_APPLN_USPC t8 on t8.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS21_APPLN_JPC t9 on t9.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS22_APPLN_LOCAR t10 on t10.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS24_CITATION_PAT t11 on t11.accsn_nb = t1.ACCSN_NB
LEFT JOIN TLS25_CITATION_NONPAT t12 on t12.accsn_nb = t1.ACCSN_NB
GO