Hi, I have attached a database that can generate Json from a Query data.
But I am trying to get Json output from a query in a specific format. (Expected Json format attached)
My Database contains 3 tables
1.Bill - Contains Invoice no. and customer details
2.BillProducts - Contains products...