check this how the join happens in database view
reference: Showing RITM variable, in the list view of a report that is referencing sysapproval_approver table
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
