Ejemplo de Operadores y Rutas

SELECT O.clave AS Clave, O.nombre AS Nombre, O.status AS Status_Operador, O.activo AS Activo_Operador, R.ruta AS Ruta, R.status AS Status_Ruta, R.activa AS Activo_Ruta FROM `catoperadores` O LEFT JOIN `catrutas` R ON O.id_ruta = R.id_ruta ORDER BY Nombre ASC;