Hello,All:
As we all know, a simple query S_q is of a standard form, i.e. select ... from ... where... group by ... having ... sorted by ...
Actually, a nested query N_q may contain other simple queries with standard form (or even other nested queries) in the where clause/from clause/having clause of N_q.
My questions are:
Whether there exists a software or a method which can convert a nested query into a simple query ?
Whether there exists a software or a method which can convert a simple query with having clause to one without having clause ?
Many thanks in advance.
As we all know, a simple query S_q is of a standard form, i.e. select ... from ... where... group by ... having ... sorted by ...
Actually, a nested query N_q may contain other simple queries with standard form (or even other nested queries) in the where clause/from clause/having clause of N_q.
My questions are:
Whether there exists a software or a method which can convert a nested query into a simple query ?
Whether there exists a software or a method which can convert a simple query with having clause to one without having clause ?
Many thanks in advance.