How can I put SELECT result set to SELECT column?
I have two tables: Job(ID,Name, etc.) and Address(ID, Job_ID, Name etc). I want to get result like this: [ { "Job_ID": 1, "JobName": "Test", "Addresses": [ { "ID": 1, "Name": "King street" }, { "ID": 2, "Name": "Queen`s street } ] } ] My current query that gets only one address for a job looks… Read More How can I put SELECT result set to SELECT column?