query pa sacar nombres de LDT

SELECT a.ambito, c.nombre FROM listadoAmbitosPatronCalidad AS a INNER JOIN listadoCargosPatronCalidad AS c ON c.id = a.id && c.idPatron = "PC_CBOOTH-4" WHERE a.idPatron = "PC_CBOOTH-4"