Hi all,
This query works fine on a 4.1 server, but not a 5.0 server:
Select *
from
agentrelationships, agents as a2
left outer join agents
on
agentrelationships.agentidparent = agents.agentid
where
agentrelationships.agentidchild = a2.agentid
On a 5.0 server, I receive 'unknown
On Fri, 2006-04-21 at 11:42 -0500, Duzenbury, Rich wrote:
Is there some known bug about combining theta and ansi style joins in
the same query? As I say, this works on a 4.1 server, and it will be
troublesome to convert all of the old queries in order to upgrade.
In MySQL 5.0.12 they changed