Example

gistfile1.sql

Channel = [
{
"creationDate": "Tue May 22 2012 17:23:11 GMT+0530 (IST)",
"id": "2642",
"lcn": "17",
"logo": "627",
"name": "ETV Marathi",
"valid": "1"
},
{
"creationDate": "Tue May 22 2012 17:23:11 GMT+0530 (IST)",
"id": "4533",
"lcn": "32",
"logo": "4017",
"name": "Akash Bangla",
"valid": "1"
}];

Img = [
{
"id": "627",
"url": "Data%2Fassets%2Fimages%2Fimg%2855%29.img"
},
{
"id": "1992",
"url": "Data%2Fassets%2Fimages%2Fimg%2884%29.img"
},
{
"id": "660",
"url": "Data%2Fassets%2Fimages%2Fimg%2888%29.img"
},
{
"id": "215",
"url": "Data%2Fassets%2Fimages%2Fimg%2820%29.img"
},
{
"id": "4017",
"url": "Data%2Fassets%2Fimages%2Fimg%2863%29.img"
}
];

return select i.url as url,c.lcn as lcn from Img as i,Channel as c
 where i.id=c.logo;