How do display a row just once in one to many releationship

Occasional Visitor

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

 

idNameidProduce_Name
1David     1Camera    
  1Mobile    
2James     2Camera    
  2Mobile    
  2IPad      
3Steve  

 

Please help 

0 Replies