[EMAIL PROTECTED] wrote:
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
Unless you are r
-Nachricht
> Datum: Fri, 31 Aug 2007 09:30:13 -0400
> Von: Baron Schwartz <[EMAIL PROTECTED]>
> An: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Betreff: Re: JOIN migration from Oracle to MySQL
> [EMAIL PROTECTED] wrote:
> > Hello,
> >
> > I've
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren'
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
selec
