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

Copper Contributor

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


1David     1Camera    
2James     2Camera    


Please help 

0 Replies