I have a table as below.
Employee Table
Id Name
1 David
2 James
3 Steve
Products Table
Id Product_Name
1 Camera
1 Mobile
2 Camera
2 Mobile
2 IPad
I want to join two tables so that the results would be as below
| id | Name | id | Produce_Name |
| 1 | David | 1 | Camera |
| | | 1 | Mobile |
| 2 | James | 2 | Camera |
| | | 2 | Mobile |
| | | 2 | IPad |
| 3 | Steve | | |
Please help
