Jarkeborn Joacim wrote:
>
> Hi,
> I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an
>error message saying that it's a syntax error.
>
> The definition in a Oracle helpfile is:
> (+), Indicates that the preceding column SELECT ename, dname
> is the outer join column FROM emp, dept
> in a join. WHERE dept.deptno =
> emp.deptno (+)
>
> How can I do this in mySQL?
>
> Here is my SQL statement:
> -----------------------------------------------------------------------
> 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_textlist t1, wi_textlist t2,
> wi_textlist t3, wi_pisection s , wi_fevss vs
> 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
> -----------------------------------------------------------------------
>
> Best regards
> Joacim
Joacim:
I don't think the (+) is standard ANSI SQL and is probably not necessary for
your Oracle query. The (+) is unnecessary. Lose it and the query will likely
work in both Oracle and MySQL.
I'm curious why you're not explicitely specifying your OUTER JOIN before the
WHERE clause which would make it a more efficient query.
CONCAT() is definitely not supported in MSSQL as of 7.0, and will cause you
problems there, but that's another issue. I'm assuming you're shooting for a
cross-sql capable application. A thought to consider.
Best Regards,
Van
--
=================================================================
Linux rocks!!! http://www.dedserius.com/
=================================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
