SharePoint 2010 - Join Two Lists (Child Parent Relation)

This article has also been published at NothingButSharePoint.

Description: This tutorial explains how to join two lists based on child parent relation without writing any code.
This post explains how to implement the child parent relationship between two lists/tables. Two lists will have one common field ID from Category list. Category.ID will act as primary key in Category list and will be used in Products list as a foreign key to match the items. Below diagram illustrate the relationship that has been implemented in the video.

Child Parent Relation

This technique can also be used in SharePoint 2007 via SharePoint Designer 2007 as explained in one of my previous posts. However the Data Source and Data View web part's menu options are little different.