Custom Search
 


Knowledge Base
MySQL Tutorials

GeeksEngine is hosted by HostGator.
Querying Multiple Tables



This section is all about how to do join operations in MySQL - selecting data from multiple tables and then put them together in one result set.


1. Using Inner Joins to Combine Data from Two Tables


2. Using Outer Joins to Combine Data from Two Tables


3. Another Example for Outer Joins (three tables)


4. Using Self Joins to Combine Data from the Same Table


5. SQL Set Operators - a Visual Guide to UNION, UNION ALL, MIMUS/EXCEPT, INTERSECT


6. Using UNION to Append Result Sets


7. Create working tables to demonstrate how to mimic set operators MINUS, EXCEPT, INTERSECT in MySQL


8. How to do MINUS/EXCEPT and INTERSECT in MySQL


9. How to Simulate Full Join in MySQL - Part 1: return both matched and unmatched rows


10. How to Simulate Full Join in MySQL - Part 2: return unmatched rows only


11. How to Simulate Full Join in MySQL - Part 3: use UNION to simulate FULL JOIN


12. Use Cross Join to Combine Data in MySQL


13. Differences Between Join and Union


Back to Tutorial Index: MySQL Database How-to Articles and Tutorials

Copyright © 2024 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.
 
Home | Feedback | Terms of Use | Privacy Policy