Node.js Express and mysql joins

Getting an "undefined" with the following sql using Node.js, Express and mysql module. 1. I'm new to Node and Express, how would you use a join for a query.

// Function to find all the shopping list
ShoppingListProvider.prototype.findAll = function(callback){
   pool.getConnection(function(err, connection) {
        // Use the connection
        connection.query( 'SELECT s.shopping_id AS shopping_id,
                          DATE_FORMAT(s.entry_date,\'%m-%d-%Y\') AS entry_date,
                           i.item_desc AS item_desc,m.shopping_list_desc AS shopping_list_desc ' + 
            'FROM shopping_list s' +
            'JOIN item_master i ON i.item_id = s.item_id' +
            'JOIN shopping_list_master m ON m.shopping_list_id = s.shopping_list_id', function(err, rows, fields) {
            if (err) callback(err);
            else {
                console.log(fields);
                callback(null,rows);
                connection.end();               
            }

        });
    });

};