Help about joins

From: JJ <jocke30_gbg_at_hotmail.com>
Date: Tue, 28 Aug 2001 11:59:39 +0200
Message-ID: <9mfq1n$8cq$1@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

---

Received on Tue Aug 28 2001 - 04:59:39 CDT