Re: Ayuda mysql basico
Hola Matias,
Tienes que tener un campo en comĂșn en las 2 tablas:
Cliente
-nombre
-apellido
-telefono
-direccion
-dni
-email
- Comun
Auto
-patente
-fecha
-observacion
- Comun
Entonces con un LEFT JOIN lo resuelves:
select cliente.nombre, cliente.apellido, auto.patente, auto.observacion
from cliente left join auto on cliente.comun = auto.comun
where cliente.nombre = 'BUSQUEDA' or cliente.apellido = 'busqueda'
Mas o menos asi, seria la consulta que resolverĂa tu problema.
Subject
Views
Written By
Posted
1658
July 24, 2014 08:19AM
Re: Ayuda mysql basico
1024
July 25, 2014 11:14AM
982
July 25, 2014 11:43AM
1029
July 25, 2014 11:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.