How to realize non-equivalent connection with sql99 Syntax in mysql

Let me tell you a little bit about how the sql99 syntax in mysql implements non-equivalent joins. Have you ever heard of similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading how the sql99 syntax in mysql implements non-equivalent connections.

# case: query the salary level of an employee

SELECT salary,grade_levelFROM employees eJOIN job_grades gON e.`salary`BETWEEN g.`lowest _ sal`AND g.`lowest _ sal`

# case: query the number of each salary grade and descend by rank

SELECT COUNT (*), grade_levelFROM job_grades jJOIN employees eON e.`salary`BETWEEN j.`lowest _ sal`and j.`highest _ sal`GROUP BY

Grade_level DESC

What do you think of this article on how to achieve non-equivalent joins in sql99 syntax in mysql? If you want to know more about it, you can continue to follow our industry information section.