I'd try a mySQL newsgroup or support forum for this sort of question.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"JJ" <jocke30_gbg_at_hotmail.com> wrote in message
news:9mftlc$ird$1_at_vg170.it.volvo.se...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tomt1ctj4o52ff_at_news.demon.nl...
> >
> > "JJ" <jocke30_gbg_at_hotmail.com> wrote in message
> > news:9mfq1n$8cq$1_at_vg170.it.volvo.se...
> > > Hi,
> > >
> > > I having trouble with 'LEFT JOIN...' and wonder if someone
> > > friendly soul can help me to translate the following and make
> > > use of LEFT JOIN... instead of the (+)?
> > >
> > > I would be _very_ happy!
> > >
> > > Best regards
> > >
> > > Joacim
> > >
> > > ---------------------------------------------------------------------
> > > SELECT f.fungroupno, f.infotypeid, f.qualifierid, f.vssno,
> > > f.vsscompany,
> > > f.vssgroupno, i.fromid, i.toid, i.linktype, s.sectionid section,
> > > LTRIM(CONCAT( t1.text, CONCAT( ' ', CONCAT( t2.text, CONCAT( '',
> > > CONCAT( t3.text, CONCAT( ' ', s.subheadtext)))))))
> > > infoelementtitle,
> > > NULL opcode, NULL optitle
> > > FROM wi_sifilter f, wi_siinfoelement i, wi_pisection s ,
> > > wi_fevss vs,
> > > wi_textlist t1,
> > > wi_textlist t2,
> > > wi_textlist t3
> > > WHERE f.infotypeid = 'PARTS' AND f.fungroupno LIKE '49%' AND
> > > f.qualifierid = 'PARTS-CATLG'
> > > AND f.infoelementid = i.fromid AND
> > > s.sectionid = i.toid AND
> > > t1.language (+) = 'eng' AND t1.country (+) = 'US' AND
> > > t1.textid (+) = s.heading1 AND
> > > t2.language (+) = 'eng' AND t2.country (+) = 'US' AND
> > > t2.textid (+) = s.heading2 AND
> > > t3.language (+) = 'eng' AND t3.country (+) = 'US' AND
> > > t3.textid (+) = s.heading3 AND
> > > i.linktype = 'partinforef' AND
> > > vs.vssno = f.vssno AND (vs.model = 'F10' OR vs.model IS NULL)
> > > ORDER BY 6 ASC, 5 ASC, 4 ASC
> > > ---------------------------------------------------------------------
> > >
> > >
> > >
> >
> > Check the sql reference manual and you will notice LEFT JOIN doesn't
exist
> > in Oracle SQL
> >
> > Regards,
> >
> > Sybrand Bakker, Senior Oracle DBA
>
> Yes, I know that LEFT JOIN doesn't exist in Oracle but there is other DBs
> that does. We have Oracle 8i as high-end solution with the SQL statement
> above, now we need a low-end solution (mySQL DB on a CD-ROM) and need to
> test.
>
> // Jocke
>
>
Received on Tue Aug 28 2001 - 06:22:10 CDT
