Hi MySQL experts
I'm new to MySQL (usually I work with T-SQL), and need your help!
I need to make a self join to solve the issue at hand, which works fine. However I would like to make query into a view, because I want to hide the complexity from the external developers.
The problem is that I get the following error: View's SELECT contains a subquery in the FROM clause
Are there any samt way to handle this i MySQL?