How to generate string json formate to this case ?

Question

I need to make json string formate suitable to select statement as following :

 

select FooterTable.LineNumber,FooterTable.ItemCode,FooterTable.Quantity,FooterTable.UniPrice,FooterTable.Total from

MasterTable inner join FooterTable on MasterTable.Serial=FooterTable.Serial,MasterTable.BranchCode=FooterTable.BranchCode,MasterTable.Year=FooterTable.Year

where MasterTable.Serial=10 AND MasterTable.Year=2019 AND MasterTable.BranchCode=1

 

No need for code by any language

only string fomate like that

{

xxxx

}

 

MasterTable

Serial pk

Year pk

BranchCode pk

 

FooterTable

Serial pk

Year pk

BranchCode pk

LineNumber

ItemCode

Quantity

UniPrice

Total

 

How to generate json string as following :

 

Fields : LineNumber,ItemCode,Quantity,UniPrice,Total specified all fields from FooterTable no fields from MasterTable .

 

Keys : Serial:10,Year:2019,BranchCode:1 from MasterTable .

 

Tables:MasterTable,FooterTable .

 

so that how to generate json format string to my requirment above