k my tables are

package_event (Id int,name nvarchar(50),fk_event int)

workscope_event (fk_user int,fk_event int)

data : Package_Event

Fk_Package, Fk_Event

1 1

2 2

3 3

4 4

5 5

6 6

6 1

data : workscope_event

Fk_User, Fk_Event

1 1

1 2

1 3

now if the user 1 logs in then the out put should be

Fk_Event , Fk_Package

1 1

2 2

3 3

for other users all the events and their packages should come.