Re: Can 0.94h no longer handle Outer Join syntax?

[Tobias Downer <toby@xxxxxxxxx>]

Try this rewrite,

  SELECT c.*, count(e.id_contact), cs.name, cs.avg_score
  FROM csr cs, contact c
  LEFT OUTER JOIN evaluation e
  ON c.id_contact = e.id_contact
  WHERE cs.id_csr = c.id_csr
  AND c.id_csr = 1

When you use an OUTER JOIN the ON expression must only contain 
references to the left and right table of the join.

Toby.

Spencer Roberts at Tellusoft wrote:
> Hi All,
> 
> I just upgraded to 0.94h from 0.94g and received this error...
> 
> This SQL:
> 
> SELECT c.*, count(e.id_contact), cs.name, cs.avg_score
> FROM contact c, csr cs
> LEFT OUTER JOIN evaluation e
> ON c.id_contact = e.id_contact
> WHERE cs.id_csr = c.id_csr
> AND c.id_csr = 1
>