[dbo].[userGroupHistory]

(local) > SupportBridge > Views > dbo.userGroupHistory

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:44:47 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Columns

Name
groupID
userID

SQL Script

create view userGroupHistory as
select gej.groupID, us.userID
from  UserSessions us  inner join
  SessionEventJoin sej on  us.sessionID = sej.sessionID
  inner join  GroupEventJoin gej on gej.eventID = sej.eventID


GO

Uses

[dbo].[GroupEventJoin]
[dbo].[SessionEventJoin]
[dbo].[UserSessions]
dbo