Database View to join tables sysapproval_approver and sc_req_item

[AndyMaier]

Has anyone joined these tables sysapproval_approver and sc_req_item, and how?

[sabrina0522]

Hi Andy, 

I had a similar request. I created a database view with sysapproval_approver and sc_req_item tables. Joined them like this: sri_sys_id=saa_sysapproval

Not sure if that helps, but figured I'd comment. 🙂 Good luck!