> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins.md).

# Joins

{% columns %}
{% column %}
{% content-ref url="/pages/Aby20KqZu56PdqNNTeVM" %}
[JOIN Syntax](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins/join-syntax.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Main `JOIN` page, documenting all join types available in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/BRHNBfBssVtfdyOTzCHv" %}
[Joining Tables with JOIN Clauses](/docs/server/mariadb-quickstart-guides/mariadb-join-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Introduction to joining tables in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/rZWdKMRnZeLyRKWmlJRU" %}
[Advanced Joins](/docs/server/mariadb-quickstart-guides/more-advanced-joins.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Introduction to advanced joins in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QJCehNVztiPPBZ78yOny" %}
[Comma vs JOIN](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins/comma-vs-join.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to use a comma instead of a `JOIN` clause, and why you should always prefer the latter.
{% endcolumn %}
{% endcolumns %}