Re: Help about joins

"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 Received on Tue Aug 28 2001 - 05:27:42 CDT