Select con varias tablas
| From: | Jorge Simón Navarro | Date: | Tue, 03 Apr 2001 21:25:40 +0000 |
| Subject: | Select con varias tablas | ||
| Groups: | php.general.es | ||
| Request: | Send a blank email to general-es+get-8719@lists.php.net to get a copy of this message | ||
La solucion al final a sido esta:
$result = mysql_db_query ("nordavia", "select * from fleet, airline where airline.base like '%hamburg%' and fleet.al_link=airline.al_link order by airline.company, num_seats")or die (mysql_error());
Aunque parece ser que depende algo de la version de mySQL que tengas instalada.
Gracias por vuestra ayuda,
Un saludo,
Jorge.