SQL retrieval and puttung in json format

Posted on September 7, 2017
I would like to get help in creating query to database and create report in json format. Query would be one to many relationship Exmaple for json format is,{"jobId":865,"jobType":"pick","user":"ADMIN","status":"complete","da