Quackit Logo
SQL Home

SQL Tutorial

Introduction
SQL Syntax
SQL Select
SQL Where
SQL Order By
SQL Top
SQL Distinct
SQL In
SQL Alias
SQL Join
SQL Inner Join
SQL Outer Join
SQL Insert
SQL Update
SQL Delete
SQL Functions
SQL Count
SQL Create
SQL Create Database
SQL Create Table
SQL Create Index
SQL Alter Table
SQL Summary
FREE Hosting!
With every domain you register with ZappyHost you get FREE hosting.
Create free Flash websites

SQL Inner Join

Print Version

As discussed in the previous lesson, you should use the SQL INNER JOIN when you only want to return records where there is at least one row in both tables that match the join condition.

Example SQL statement

SELECT * FROM Individual
INNER JOIN Publisher
ON Individual.IndividualId = Publisher.IndividualId
WHERE Individual.IndividualId = '2'

Source Tables

Left Table

IdFirstNameLastNameUserName
1FredFlinstonefreddo
2HomerSimpsonhomey
3HomerBrownnotsofamous
4OzzyOzzbournesabbath
5HomerGainnoplacelike

Right Table

IndividualIdAccessLevel
1Administrator
2Contributor
3Contributor
4Contributor
10Administrator

Result

IndividualIdFirstNameLastNameUserNameIndividualIdAccessLevel
2HomerSimpsonhomey2Contributor

Next lesson covers the SQL OUTER JOIN.

Enjoy this website?

  1. Add this page to your Favorites
  2. Link to this page (copy/paste into your own website or blog):
  3. Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!
Need Website Content?
Get unique, quality digital content for your website.
  • 270+ Website Templates
  • 800+ Flash Templates
  • 25,000+ Images, Logos
  • 30,000+ e-Books
  • 15,000+ Scripts
  • 27,000+ Animated GIFs
  • 21,000+ Ringtones
  • ...and much more!
Get your content now!
$1.99 .info domain names!
© Copyright 2000 - 2010 Quackit.com