Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for Nested Joins? #117

Open
courtney-miles opened this issue Jul 15, 2020 · 0 comments
Open

Support for Nested Joins? #117

courtney-miles opened this issue Jul 15, 2020 · 0 comments

Comments

@courtney-miles
Copy link

Does php-sql-query-builder have support for nested joins?

I.e. Can it describe the following query:

SELECT *
FROM t1
  LEFT JOIN (t2, t3) ON (t1.a = t2.a AND t2.b = t3.b)

So the above is LEFT JOIN to the results of an INNER JOIN between t2 and t3. Note that this JOIN statement can also be described using standard SQL as LEFT JOIN (t2 CROSS JOIN t3).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant