how to get two tables data based on column

We have two tables Table1 and table2. Table1 have A,B,C columns and Table2 have B,E,F columns.

Table1                    Table2
A      B     C         B      E     F
raja   21   HYD        21     AP   60000000
raju   21   VJY        
ravi   21   BEG

We need is 
A      B    C     E    F
raja   21   HYD   AP   60000000
raju   21   VJY   AP   60000000 
ravi   21   BEG   AP   60000000 

so We tried like this

tx.executeSql('SELECT r.A as name,r.B as age,r.C as city,s.E as state,s.F as distance from table1 r Left JOIN table2 s on r.B=s.B',[],joinsuccess,errorCB);
    function joinsuccess(tx,result){
            var JOINLength = result.rows.length;
             for (var i=0; i<JOINLength; i++){
             console.log(result.rows.item(i).name);
             console.log(result.rows.item(i).age);
             console.log(result.rows.item(i).city);
             console.log(result.rows.item(i).state);
             console.log(result.rows.item(i).distance);
}
    }

but it's we got only

ravi   21   BEG  AP   60000000

Please any one guide me.Please any one tell me what wrong in mycode.

Thanks in Advanced.