Hola buenos días, que forma de hacer los join consideran que es la más aconsejable usar, es que verán los he visto hacer de estas dos formas,
            select *  from averias
          1-> inner join cajeros on  ( averias.id_cajero = cajeros.id_cajero)
          2-> inner join cajeros on cajeros.id_cajero = averias.id_cajero

List<String> listaColores2 = new ArrayList<String>() {
            {
                add("Rojo");
                add("Verde");
                add("Azul");
                add("Amarillo");
                add("Rosa");
            }
        };
        System.err.println("datos Sin Ordenar -> " + listaColores2);
        Collections.sort(listaColores2);
        System.err.println("datos Odenador asc" + listaColores2);
        Collections.sort(listaColores2, new Comparator<String>() {
            @Override

DV2selection = "5-Series";
newArray = [];
for (i = 0; i < myData.length; i++) {
    if (myData[i].Series === DV2selection ) {
        console.log(myData[i].Series);
    }
};

for (i = 0; i < myData.length; i++) {
    if (myData[i].Make === DV1selection && myData[i].Series === DV2selection && myData[i].Model === DV3selection && myData[i].Type === DV4selection && myData[i].Year === DV5selection) {
        veicSelecionado = document.createElement('li');
        veicSelecionado.innerHTML = ('Make: ' + myData[i].Make);
        DV6.appendChild(veicSelecionado);

        veicSelecionado = document.createElement('li');
        veicSelecionado.innerHTML = ('Series: ' + myData[i].Series);

{
            "Make": "ALFAROMEO",
            "Series": "33",
            "Model": "33",
            "Type": "905",
            "Year": "83-89",
            "Frontlength": "-",
            "Frontnewton": "-",
            "Frontpistonmod": "-",
            "Frontbottlemod": "-",
            "Rearlength": "547",
            "Rearnewton": "300",
            "Rearpistonmod": "-",
            "Rearbottlemod": "-"
        },

var client = new HttpClient();
client.get(theurl, function(response) {
    myData = JSON.parse(response);
});

while (DV6.hasChildNodes()) {DV6.removeChild(DV6.firstChild);}

var target = event.target.innerHTML;
event.target.className += " active";
DV5selection = target;

veicSelecionado = document.createElement('li');
veicSelecionado.innerHTML = ('SELECTED VEHICLE:');
DV6.appendChild(veicSelecionado);

var myArr = [];
var valueToPush = { };
for (i = 0; i < myData.length; i++) {

    if ( $("#make_items_"+myData[i].Make+"_"+myData[i].Model).length > 0 ) {
        veicSelecionado = document.createElement('li').attr("id","make_items_"+myData[i].Make+"_"+myData[i].Model);

if (myData[i].Series === DV2selection ) {
    veicSelecionado = document.createElement('li').attr("id","make_items_"+myData[i].Series);
    veicSelecionado.innerHTML = ('Make: ' + myData[i].Make);
    DV6.appendChild(veicSelecionado);
}

{
            "Make": "ALFAROMEO",
            "Series": "33",
            "Model": "33",
            "Type": "905",
            "Year": "83-89",
            "Frontlength": "-",
            "Frontnewton": "-",
            "Frontpistonmod": "-",
            "Frontbottlemod": "-",
            "Rearlength": "547",
            "Rearnewton": "300",
            "Rearpistonmod": "-",
            "Rearbottlemod": "-"
        },
        {
            "Make": "ALFAROMEO",
            "Series": "33",
            "Model": "33",

if ( document.getElementById(`make_items_${myData[i].Series}_${myData[i].Model}`).length >0 ) {
    DV6.innerHTML = `
    <li id = make_items_${myData[i].Series}_${myData[i].Model}>Make: ${myData[i].Make}</li>
    `;
}

if (myData[i].Series === DV2selection ) {

            if ( myData[i].Series >0 ) {

                veicSelecionado = document.createElement('li');
                veicSelecionado = "make_items_"+myData[i].Series;
                console.log(veicSelecionado);
            }
        }

for (i = 0; i < myData.length; i++) {
    if (myData[i].Series === DV2selection ) {
        if ( parseInt(myData[i].Series) >0 ) {
            veicSelecionado = document.createElement('li');
            veicSelecionado.innerHTML = ('Make: ' + myData[i].Series);
            DV6.appendChild(veicSelecionado);
        }
    }
}