OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Complex (nested?) left join

From: Jean-Michel OLTRA (jm.oltraespinasse.net)
Date: Wed Jun 30 2004 - 01:23:31 CDT

        bonjour,

Le mercredi 30 juin 2004, David Taylor a écrit...

> I'm trying variations on LEFT JOIN.

Is there necessary ? Phones and fax numbers are related to companies, so
INNER JOIN would be enough. No ?

> SELECT C.CONTACTID, FIRSTNAME, LASTNAME, COMPANY,

 SELECT DISTINCT ......
 
--
jm

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb