MySQL Forums
Forum List  »  Spanish

Re: Ayuda mysql basico
Posted by: Carlos Soto
Date: July 25, 2014 11:14AM

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.

Options: ReplyQuote


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.