Re: Help about joins

"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:01:20 CDT