Page Comparison

CREATE VIEW [dbo].vwEventInformations
AS
SELECT 
    m.ID  'ID',
    m.MeetingTitle  'EventName',
     
m.StartDate  'StartDate',
     
m.EndDate  'EndDate',    
    e.FirstLast  'PlannerName',    
    CASE WHEN e.WorkAreaCode IS NULL THEN  e.WorkPhone else '(' + e.WorkAreaCode + ')' + e.WorkPhone end   'PlannerPhone',  


    e.HomeFax  'PlannerFax',
      
e.WebPage  'PlannerURL',
      
e.Email1  'PlannerEmail', 
 
    e.FirstLast  'PlannerContactName', 


   
m1.MeetingID  'MeetingID',


   
m.VerboseDescription  'Description', 


   
p.WebProductPage  'Website'


FROM 


   
Meeting m


   
LEFT OUTER JOIN 


       
vwEmployees    e 


       
ON 


            m.CoordinatorID=e.ID


   
LEFT OUTER JOIN 


       
vwMeetings    m1 


       
ON 


            m.ID=m1.ID


   
LEFT OUTER JOIN 


       
Product    p 


       
ON 


            m.ProductID=p.ID