SELECT (a.mesa) AS MESA, (a.mesagrupo) AS CARTAO, (b.nome) AS 'ABERTO POR' FROM mesas AS a INNER JOIN empregados AS b
ON a.emp = b.codigo ORDER BY a.mesa