Creating a report from two different tables

Hello SN Comm,

I am looking to see if anyone here can help me in my research with a possible task.

We use HR Case for our main table (Case Management) - and we also use KB Knowledge. It has been requested to see if a certain report can be built.

Request: Build a report that can look up 'Knowledge Articles flagged as not helpful/more info needed' & within the same report, list of HR Cases 'flagged as needing knowledge'.

Findings (so far): I have been able to see that I can do some dot-walking from the Task Table, Incidents, and Problem tables. However, unable to reconcile doing the same with HR Case and Knowledge tables. Anyone know if there is a way to do what I am looking for?

Note: If I did not explain enough detail please let me know and I an try again.

Thanks in Advance!

-Rob