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]