មេរៀនទី២១: SQL Inner Join

លោកអ្នកអាចប្រ SQL INNER JOIN កាលណាចង់ត្រឡប់ចូល records មានយ៉ាងតិចក៏ row មួយក្នុងតារាងពីរ ក្នុងលក្ខខ័ណ្ឌ join condition។
ឧទាហរណ៍ SQL statement
SELECT * FROM Individual
INNER JOIN Publisher
ON Individual.IndividualId = Publisher.IndividualId
WHERE Individual.IndividualId = ’2′
Source Tables
Left Table

Id	FirstName	LastName	UserName
1	Fred	Flinstone	freddo
2	Homer	Simpson	homey
3	Homer	Brown	notsofamous
4	Ozzy	Ozzbourne	sabbath
5	Homer	Gain	noplacelike

Right Table

IndividualId	AccessLevel
1	Administrator
2	Contributor
3	Contributor
4	Contributor
10	Administrator

Result

IndividualId	FirstName	LastName	UserName	IndividualId	AccessLevel
2	Homer	Simpson	homey	2	Contributor

Next lesson covers the SQL OUTER JOIN.