RE: OUTER JOIN

[David Shelley]

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]