Tables "client" an "user" are quite similar, but they don't have any intersection, I mean, if somebody is a client, he or she cant be a user. So, I have his or her driving license and I need to know what kind of person is.
Im trying some join left, right, but I'm unable to get it!! RocÃo Gómez Escribano r.go...@ingenia-soluciones.com PolÃgono Campollano C/F, nº21T 02007 Albacete (España) Tlf:967-504-513 Fax: 967-504-513 www.ingenia-soluciones.com -----Mensaje original----- De: Halász Sándor [mailto:h...@tbbs.net] Enviado el: miércoles, 04 de mayo de 2011 22:43 Para: Rocio Gomez Escribano CC: mysql@lists.mysql.com Asunto: Re: RV: independent tables >>>> 2011/05/04 16:57 +0200, Rocio Gomez Escribano >>>> I suppose my solution is an Join, but they have no intersection <<<<<<<< Really? Your examples are very much like a simple join, a special case of ... client OUTER JOIN user ON clientCodeDrivingLicense = userCodeDrivingLicense What is wrong with that? (although actually MySQL does not do full outer joining. It is needful to get that through a union of left join and right join, care taken that the inner join in only one of them appear.) Actually, your tables "client" and "user" look like the same table with field names changed, no other difference. Field names have nothing to do with intersection. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
