if wrong I downvoted---

I need to write query for JDBC template to join data from 2 tables in a following way:

{ "country_id": "JAP", "city_id": "53", "data": { "model": "Toyota", "details": { "weight": "900", "description": "Family Car." }, "factory": { "amount": "1", "color": "100", "additions": [ "AC", "Parctronic" ] } } } 

Generally say, I need to join this:

('JAP', '53', ('{"model":"Toyota","weight":"900","description":"Family Car." 

and this:

('{"amount":"1","color":"100","additions":["AC","Parctronic"]}')