Comments (1)
This is a dup of #80. I'm leaving this open in the hopes that I'm able to persuade you to please change the "JOIN" to an "INNER JOIN" in the "Aliasing or correlations" section; not because it's wrong, but just to reduce confusion for teams which require explicit join types and want to use this formatting guide. (Also, that this is causing confusion is hopefully evidenced by the two independent issues (this one and #80 created for that section).
I understand now from #22 that both versions are correct, but since this is the first time many readers will see the recommended formatting for a join, I'd just ask that the first example use the more explicit INNER JOIN to reduce the chance of confusion. Either way, feel free to close this issue after reading, and thanks.
from sqlstyle.guide.
Related Issues (20)
- clicking link doesn't update fragment in URL HOT 3
- add link for OOP design vs. SQL HOT 3
- Grammer error in German translation HOT 1
- Audit columns HOT 1
- This guide is fantastic HOT 1
- Italian translation HOT 6
- CHECK pens_in_drawer violates "preferred formalisms" re. BETWEEN HOT 1
- Order of foreign key? HOT 1
- Backticks (backquotes?) in style. HOT 2
- Naming convention for boolean columns HOT 3
- Some additional uniform-suffixes for consideration HOT 1
- JOIN in Aliasing or correlations example not indented right HOT 1
- ISO Date/Time Format HOT 2
- How are you aligning the first word on each line? HOT 2
- Ukrainian translation suggestion
- [just suggestion] from gitlab style (indentation 2 spaces) HOT 1
- Reconsider JOIN Style
- Mine
- https://sqlstyle.guide gives cloudflare's ssl exception 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 sqlstyle.guide.