it should be an easy requirement provided you know what's the common field in those tables
Also you are missing where clause for 1 of the view table
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
