Merging Two Tables in Report

Question

Hi, i want to merge two table Fields in Crystal Report. the tables having one common field and the first table contain one row of data and the second table contain four row of data  i want the SQL query to display the Unique Data of two tables in report.
 

Example: Table1 Contain Fields Name,Course Code,Course Name etc.,- 1 Row
 
Table2 Contain Fields Course Code,Software,Course Ware - 4 Rows 
 

Now i want to merge this two tables and Need to display the Unique data in Crystal report.