Skip to content
This repository has been archived by the owner on May 14, 2024. It is now read-only.

query builder with sub query in FROM #410

Open
tuta2-rikkeisoft opened this issue Oct 18, 2022 · 0 comments
Open

query builder with sub query in FROM #410

tuta2-rikkeisoft opened this issue Oct 18, 2022 · 0 comments

Comments

@tuta2-rikkeisoft
Copy link

I am having a issue with SQL with FROM clause like this how can I turn this into query builder. Can someone help me

FROM tab1 AS t0 LEFT OUTER JOIN tab2 AS t1 ON t0.id = t1.id LEFT OUTER JOIN tab3 AS t2 ON t1.id = t2.id LEFT OUTER JOIN ( SELECT id, COUNT( member_id ) AS denominator FROM tab4 WHERE id = {id} (this is param) GROUP BY id ) as t3 on t0.id = t3.id

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

No branches or pull requests

1 participant