Comments (2)
Reformatted, but still with the parentheses:
SELECT
RAYON.NAME,
Count(DOGOVOR.NDOG) AS Count_NDOG,
Sum(DAY.DA) AS Sum_DA
FROM (
(
RAYON
INNER JOIN OSNADRES ON RAYON.KRN = OSNADRES.KRN
) INNER JOIN (
DOGOVOR LEFT JOIN DAY ON DOGOVOR.NDOG = DAY.NDOG
) ON OSNADRES.ARXNOM = DOGOVOR.ARXNOM
) INNER JOIN DOLGIPODOG ON DOGOVOR.NDOG = DOLGIPODOG.NDOG
GROUP BY RAYON.NAME
ORDER BY RAYON.NAME;
I have never seen anything like that before. I'm afraid you will have trouble building exactly that query with Aura.SqlQuery.
from aura.sqlquery.
Specifically, it looks like the problem is with the parentheses in the FROM/JOIN statements. I've not seen that kind of sub-FROM sub-JOIN before and can't imagine how to make it work in SqlQuery.
from aura.sqlquery.
Related Issues (20)
- Improve IN statement for 3.0 release HOT 8
- Please release 2.8 HOT 2
- Placeholder triples for where() and having() clauses
- New feature: Adding support for bigQuery standard sql HOT 1
- Inline interfaces for WHERE, ORDER BY statements, etc. HOT 3
- Is this project dead? HOT 5
- how can i add concat in select
- To add IGNORE statement to INSERT query library has different interfaces
- Update '->where' method with binding params don't working HOT 2
- # in column name HOT 2
- Is this a coding bug? HOT 2
- Where with parentheses
- What is the future of this project? HOT 2
- Security: SQL injection is possible though table names, column names, etc. HOT 5
- Allow passing query to `union()`
- when updating, add to the existing value in the table HOT 2
- how to execute a query using: USE INDEX? HOT 1
- Named placeholder don't work in where() HOT 1
- New release? HOT 3
- 3.x Stable Release? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from aura.sqlquery.