X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2022 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Data Manipulation » Selecting Data » Joins & Subqueries
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here
Product Versions

Joins & Subqueries

Documentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.

  • Joins

    Querying from multiple tables.
  • Subqueries

    Queries within queries.
  • UNION

    Combine the results from multiple SELECT statements into a single result set.
  • 1

    EXCEPT

    Subtraction of two result sets.
  • INTERSECT

    Records that are present in both result sets will be included in the result of the operation.
  • Precedence Control in Table Operations

    Controlling order of execution in SELECT, UNION, EXCEPT, and INTERSECT.
  • MINUS

    Synonym for EXCEPT.
  • ← SELECT
  • ↑ Selecting Data ↑
  • LIMIT →
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ Selecting Data ↑
  • SELECT
  • Joins & Subqueries
  • LIMIT
  • ORDER BY
  • GROUP BY
  • Common Table Expressions
  • SELECT WITH ROLLUP
  • SELECT INTO OUTFILE
  • SELECT INTO DUMPFILE
  • FOR UPDATE
  • LOCK IN SHARE MODE
  • Optimizer Hints
  • PROCEDURE
  • HANDLER
  • DUAL
  • SELECT ... OFFSET ... FETCH
Products
  • MariaDB Platform
  • MariaDB SkySQL
  • Pricing
  • Download MariaDB
Services
  • Remote DBA
  • SkyDBA
  • Enterprise Architect
  • Technical Support
  • Migration Practice
  • Consulting
  • Training
Resources
  • Documentation
  • Developers
  • Blog
  • Support
  • OpenWorks
  • Customer Stories
  • Events
  • MariaDB Roadshow
About
  • Contact
  • Leadership
  • Partners
  • Newsroom
  • Investors
  • Careers
  • Trust Center
  • Vulnerability Reporting
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2022 MariaDB. All rights reserved.