- INNER, OUTER, cross, natural, and self joins.
- Returns only matching records from each joined table.
- dbname.tablename AS a
- LEFT, RIGHT, FULL, right excluding, and left excluding.
- Includes all rows from the right table that don't match records in the left table.
- Associates columns of the same name in the joined tables with each other. It's similar to an inner join or left outer join.
- It returns a combination of every row from two tables.
- UNION removes duplicates and UNION ALL doesn't.
- By using DISTINCT in SELECT clause and an INNER JOIN.
- By ensuring you use the indexes that are on the tables or by adding indexes to the tables.
- Tech Categories
- Best Sellers
- New Releases
- Books
- Videos
- Audiobooks
Tech Categories Popular Audiobooks
- Articles
- Newsletters
- Free Learning
You're reading from Learn SQL Database Programming
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush
Unlock this book and the full library FREE for 7 days
Author (1)
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush