function viewRoles() {
    var query = 'SELECT * FROM role';
    connection.query("SELECT employee.first_name, employee.last_name, role.title AS Title FROM employee JOIN role ON employee.role_id = role.id;", 
    function(err, res) {
    if (err) throw err
    console.table(res)
    questions();
    })
}
// view all roles in the database

view all roles in the database
view all roles in the database
function viewRoles() {
    var query = 'SELECT * FROM role';
    connection.query("SELECT employee.first_name, employee.last_name, role.title AS Title FROM employee JOIN role ON employee.role_id = role.id;", 
    function(err, res) {
    if (err) throw err
    console.table(res)
    questions();
    })
}
function viewRoles ( ) { var query = 'SELECT * FROM role' ; connection . query ( "SELECT employee.first_name, employee.last_name, role.title AS Title FROM employee JOIN role ON employee.role_id = role.id;" , function ( err , res ) { if ( err ) throw err console . table ( res ) questions ( ) ; } ) }
view all roles in the database
view all roles in the database