How to use .then(function(success){ .then(function(scess){ alert(success.rows.item(0).id);});})

How to use function in function like

.then(function(success){ .then(function(scess){ alert(success.rows.item(0).id);});})

var query = "SELECT * FROM inventory WHERE status=1"; $cordovaSQLite.execute(db, query, []).then(function(success) { for(var i=0;i<success.rows.length;i++){ var queryw = "SELECT * FROM purchase WHERE inventory_id="+success.rows.item(i).id+""; $cordovaSQLite.execute(db, queryw, []).then(function(sccess) { var kkk=0; if(sccess.rows.item(0).remain==''){kkk=0;}else{kkk=sccess.rows.item(0).remain;} alert(success.rows.item(i).id+'--'+success.rows.item(i).name+'--'+sccess.rows.item(0).remain); $scope.isuccs.push({id:success.rows.item(i).id,name:success.rows.item(i).name,price:success.rows.item(i).price,qty:kkk}); },function (error) {alert("Error last inventory"); }); } $scope.selectedItem=[]; $scope.selectedItem={price:''}; }, function (error) { //console.error(err); alert("Error retrieving inventory"); });