SQL Joins Support
The cluster discusses the support for SQL JOIN operations in a specific database or query tool, highlighting concerns about their absence in examples, performance issues, and alternatives like denormalization or single-table designs.
Activity Over Time
Top Contributors
Keywords
Sample Comments
Can it do joins? I may have missed it in the doc.
The joins should be done inside the DB, not in an external server. Any SQL DB should be able to do that.
Are you implying you're not supposed to use joins in SQL?
What do you mean? It takes SQL queries. You use the `JOIN` keyword in the SQL to do joins.
Did you consider Clickhouse? join's are slow, but if your data is in a single table, it works really well.
wait, what? doesn't support joins? Things like this make me doubt my fundamentals. 'Are joins really necessary?' is the question now running through my mind ;-)
Errm, we're talking about performance of joins
https://selectstarsql.com/ may help you for JOIN I recommend that your do it in its entirety even if you understand the first concepts
That sounds like a join by another name :)
Did you look at the queries? There is not a single join in any of them.