title: how to join two views in single View in sql?
body: <p>I have two Views I want to merge into single view for example </p>
  
  <p>View 1 is defined as:</p>
  
  <pre><code>CREATE VIEW view1 AS
  select DV.demValueId,DV.value,DE.demElementId,DE.name,
         DES.demElementSetGroupId,DR.demRecordId,DR.name as Role,
         DR.demClusterSetGroupRef,L.EmailId 
  from DemographicsDataValue DV 
  inner join DemographicsElement DE 
        on DV.demValueId=DE.demValueRef 
  inner join DemographicsElementSet DES 
        on DE.demElementId=DES.demElementRef 
  inner join DemographicsRecord DR 
       on DR.demElementSetGroupRef=DES.demElementSetGroupId 
  inner join LoginDetail L 
       on DR.demRecordId=L.demRecordIdRef
  </code></pre>
  
  <p>View 2 is defined as:</p>
  
  <pre><code>CREATE VIEW view2 
  AS
  select DV.valueId, DV.value,E.ElementId,E.name,
         ES.ElementSetGroupId,ET.entryId,ET.name as E_Name,
         ET.SystemDateTime,C.compositionId,C.linkSetRef 
  from DataValue DV 
  inner join Element E 
        on DV.valueId=E.valueRef 
  inner join ElementSet ES 
        on E.ElementId=ES.ElementRef 
  inner join Entry ET 
        on ES.elementSetGroupId=ET.elementSetGroupRef 
  inner join EntrySet ESG 
        on ESG.entryRef=ET.entryId 
  inner Join Section S 
        on s.entrySetGroupRef=ESG.entrySetGroupId 
  inner join SectionSet SS 
        on SS.sectionRef=S.sectionId 
  where S.name='Appointment'
  </code></pre>
  
  <p>How do I combine them into a single view
       select * from View1
       Select * from View2</p>
  
  <p>output into single query </p>
  
  <p>please help</p>