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 ON
m.ProductID=p.ID |