I need to build a summary of requests with all details and contact associated for that job.

I am building a report of a list of outstanding (open & on hold) requests with:

Technician assigned to, requested by, time& date logged, request description and subject, work log technician, worklog description and time, conversation summary and description.

 

I just cant find out how to join to the table [NotificationContent] which I beleive hold the coversation descriptions.

 

Can any one help me out?