Try something like select distinct S.US_FOLIO US_FOLIO , ifnull(SD.US_FOLIO,'false') FOLIO2 from SEGUIMIENTO S LEFT OUTER JOIN SEGUIMIENTO_DETALLE SD on (S.US_FOLIO=SD.US_FOLIO)
-----Original Message----- From: Gustavo Mejia [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:54 PM To: [EMAIL PROTECTED] Subject: OUTER JOIN Hi, I am trying to do something like: select distinct S.US_FOLIO US_FOLIO , ifnull(SD.US_FOLIO,'false') FOLIO2 from SEGUIMIENTO S ,SEGUIMIENTO_DETALLE SD where S.US_FOLIO=SD.US_FOLIO(+) this is using Oracle, but I need to change it to mysql, I have been trying with the operator <=> but I got nothing, could you give a hand with this please ? Thanks a Lot.! Gustavo Mejia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]