MySQL Forums
Forum List  »  Spanish

Re: Como hacer una consulta a 2 tablas simultaneamente?
Posted by: Joaquín Alcañiz
Date: August 21, 2007 05:39AM

Por ejemplo:

SELECT a.id, a.email, a.cb_rut, a.cb_pais, a.cb_cuidad, a.cb_estadocivil, b.name, b.email, b.lastvisitdate
from #__comprofiler a join #__users b on b.id = a.id ORDER BY a.id.

Hay muchas otras formas.
Necesitas un cursillo SQL urgentemente, esto es básico.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Como hacer una consulta a 2 tablas simultaneamente?
5839
August 21, 2007 05:39AM


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.