Skip to content

Instantly share code, notes, and snippets.

@fabriciosanchez
Created February 14, 2017 18:59
Show Gist options
  • Save fabriciosanchez/839eb8dcacbce10b29000bef24f382a6 to your computer and use it in GitHub Desktop.
Save fabriciosanchez/839eb8dcacbce10b29000bef24f382a6 to your computer and use it in GitHub Desktop.
Creating a new view based on raw selection
create view IPR as
select Activities.ActivityName as activity, Technologies.TechnologyName as technology, Appointments.AppointmentUserUniqueName as uniquename
from Appointments
inner join WorkloadBacklogs on Appointments.AppointmentWorkloadWBID = WorkloadBacklogs.WBID
inner join Activities on WorkloadBacklogs.WBActivityActivityID = Activities.ActivityID
inner join WorkloadBacklogTechnologies on WorkloadBacklogs.WBID = WorkloadBacklogTechnologies.WorkloadBacklogWBID
inner join Technologies on WorkloadBacklogTechnologies.TechnologyTechnologyID = Technologies.TechnologyID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment