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.


regards,
Spiker



-------- Original-Nachricht --------
> Datum: Fri, 31 Aug 2007 09:30:13 -0400
> Von: Baron Schwartz <baron@xaprb.com>
> An: spikerlion@gmx.de
> CC: mysql@lists.mysql.com
> Betreff: Re: JOIN migration from Oracle to MySQL

> spikerlion@gmx.de 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't accepted.
> >
> > example:
> > select ...
> > from
> > tableA PT1 LEFT OUTER JOIN tableC bl ON (PT1.ID = bl.PARENTTYPE_1),
> > tableB PT2 LEFT OUTER JOIN tableC bl ON (and PT2.ID = bl.PARENTTYPE_2),
>
> The exact error message would be helpful, but I'm seeing at least two
> problems:
>
> 1) you're aliasing two tables as 'bl'. The aliases need to be unique.
> 2) The second ON clause shouldn't start with AND.
>
> Otherwise you should have no problem doing this.

--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser