I have 2 tables:
a) Employees
EmployeeId: 1
EmployeeName: Maria
EmployeeId: 2
EmployeeName: Jose
EmployeeId: 3
EmployeeName: Junior
b) Products
Id: 1
ProductName: Book
EmployeeId: 1
Id: 2
ProductName: Pen
EmployeeId: 2
Id: 3
ProductName: Box
EmployeeId: 1
So I would like to have something like:
EmployeeId: 1, EmployeeName: Maria, Products: Book, Pen
But I will need convert it to Json to have something like:
{
employeeId: 1,
employeeName: Maria,
products {
productName: Book,
productName: Box
}
}
Whats the best way to do it ?
Thx