<div dir="ltr">Leo, bueno, ahí me salió, costó pero salió.<div>Lo interpreto como dos consultas en una...<br><div style>y si hay otra forma de hacerlo, me avisarías?</div><div><br></div><div><br></div><div><div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"><b><font color="#000000">SELECT </font></b>per.apellido,</font></div>
<div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> per.nombre,</font></div><div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> per.direccion1,</font></div>
<div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> loc.localidad,</font></div><div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"><span style="white-space:pre"> </span>prov.provincia,</font></div>
<div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> per.direccion2, </font></div><div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> loc_2.localidad,</font></div>
<div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"> prov_2.provincia</font></div><div><font face="verdana, sans-serif" style="background-color:rgb(255,255,255)"><b>FROM </b>personas <b>as </b>per</font></div>
<div><span style="background-color:rgb(255,255,255)"><font face="verdana, sans-serif"><b> JOIN </b>localidades<b> as </b>loc</font><b style="font-family:verdana,sans-serif"> ON </b><span style="font-family:verdana,sans-serif">per.id_ciudad1=<a href="http://loc.id">loc.id</a></span></span></div>
<div><span style="background-color:rgb(255,255,255)"><font face="verdana, sans-serif"><b> JOIN </b>provincias <b>as </b>prov </font><b style="font-family:verdana,sans-serif"> ON </b><span style="font-family:verdana,sans-serif">loc.id_provincia=<a href="http://prov.id">prov.id</a></span></span></div>
<div><span style="background-color:rgb(255,255,255)"><font face="verdana, sans-serif"><b> JOIN </b>localidades<b> as </b>loc_2 </font><b style="font-family:verdana,sans-serif"> ON </b><span style="font-family:verdana,sans-serif">per.id_ciudad2=<a href="http://loc_2.id">loc_2.id</a></span></span></div>
<div><span style="background-color:rgb(255,255,255)"><font face="verdana, sans-serif"><b> JOIN </b>provincias <b>as </b>prov_2</font><b style="font-family:verdana,sans-serif"> ON </b><span style="font-family:verdana,sans-serif">loc_2.id_provincia=<a href="http://prov_2.id">prov_2.id</a></span></span></div>
</div></div><div><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif">está probado por supuesto, y funciona !</span></div><div style><span style="font-family:verdana,sans-serif"><br>
</span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div>
<div style><span style="font-family:verdana,sans-serif">Aquí las pruebas, ésto es lo que devuelve:</span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><table id="table_results" class="" style="border-collapse:collapse;color:rgb(68,68,68);font-family:sans-serif;font-size:12.727272033691406px">
<thead><tr><th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60per%60.%60apellido%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">apellido</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60per%60.%60nombre%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">nombre</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60per%60.%60direccion1%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">direccion1</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60loc%60.%60localidad%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">localidad</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60prov%60.%60provincia%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">provincia</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60per%60.%60direccion2%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">direccion2</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60loc_2%60.%60localidad%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">localidad</a></span></th>
<th class="" style="color:rgb(0,0,0);background-image:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204));border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);padding:0.3em;margin:0.1em;vertical-align:top">
<span style="display:block;overflow:hidden"><a href="http://localhost/phpmyadmin/sql.php?db=arielf&table=personas&sql_query=SELECT++per.apellido%2C%0A++++++++per.nombre%2C%0A++++++++per.direccion1%2C%0A++++++++loc.localidad%2C%0A%09%09prov.provincia%2C%0A%09%09per.direccion2%2C+++++++%0A%09%09loc_2.localidad%2C%0A++++++++prov_2.provincia%0AFROM+personas+as+per%0AJOIN+localidades+as+loc%0AON+per.id_ciudad1+%3D+loc.id%0AJOIN+provincias+as+prov%0AON+loc.id_provincia+%3D+prov.id%0AJOIN+localidades+as+loc_2%0AON+per.id_ciudad2+%3D+loc_2.id%0AJOIN+provincias+as+prov_2%0AON+loc_2.id_provincia+%3D+prov_2.id%0AORDER+BY+%60prov_2%60.%60provincia%60+ASC&session_max_rows=30&token=80561d723a72966c689f8bd948e12cf1" style="text-decoration:none;color:rgb(35,90,129);outline:none">provincia</a></span></th>
<td style="padding:0.3em;margin:0.1em;vertical-align:top"></td></tr></thead><tbody><tr class=""><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">fernandez</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">ariel</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">siria 1833</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Mar del Plata</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Buenos Aires</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">langueyu 950</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Tandil</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">Buenos Aires</span></td></tr><tr class="" style="background-color:rgb(223,223,223)"><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">fernandez</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">damian</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">valentin gomez 2000</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Flores</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">Capital Federal</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">avellaneda 1833</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">Alvear</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Corrientes</span></td>
</tr><tr class="" style="background-image:-webkit-linear-gradient(top,rgb(206,214,223),rgb(182,198,215));color:rgb(0,0,0)"><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">vivani</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">graciela</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">william morris 500</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Arroyito</span></td>
<td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">Córdoba</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">colon 154</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">San Martín de Los Andes</span></td><td class="" style="padding:0.3em;margin-bottom:12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">
<span style="display:block;overflow:hidden">Neuquén</span></td></tr></tbody></table></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif"><br>
</span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif"><br></span></div><div style><span style="font-family:verdana,sans-serif">Saludos</span></div>
<div style><span style="font-family:verdana,sans-serif"><br></span></div></div>