Forum Discussion
rakeshkumarmahanty
Aug 20, 2019Copper Contributor
How do display a row just once in one to many releationship
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
No RepliesBe the first to reply