ahmed elbarbary

ahmed elbarbary

  • 1.5k
  • 372
  • 14.5k

How to generate string json formate to this case ?

Sep 21 2019 1:19 AM
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

Answers (1)