Query Builder Nest Joins at the end of the Query

Query Builder Nest Joins at the end of the Query

iRedds
Senior Member
Posts: 662
Threads: 36
Joined: Apr 2019
Reputation: 45

03-30-2022, 07:08 PM

It's impossible.

In version 4.2, subqueries will become available in the FROM clause.
If your query can work through subqueries, then perhaps this will solve your problem.

Code:
SELECT * FROM (SELECT * FROM t1 JOIN t2) as t3,  (SELECT * FROM t4 JOIN t5) as t6

Messages In This Thread

Query Builder Nest Joins at the end of the Query - by ElTomTom - 03-30-2022, 02:20 PM

RE: Query Builder Nest Joins at the end of the Query - by iRedds - 03-30-2022, 07:08 PM