Retrieve data from multiple tables from sqlite database titanium

I have a question, I was trying to retrieve data from multiple tables from sqlite database with titanium using select statement with left join property. it retrieve null or undefined and I used this statement with sqlite administrator, it retrieves data.

You can check my code:

var db = Ti.Database.install('Path/DB_Name.s3db', 'DB_Name'); var rows = db.execute('select c.CustomerID,c.Name, c.CustomerCode,v.ConfirmationDate from Customer as c left join Visits as v on c.CustomerID==v.CustomerID order by v.ConfirmationDate desc');

Thanks.