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 column
agentrelationships.agentidparent in on clause'.
If I rework the query to change the theta style joins to ansi style
joins, it works fine.
Select *
from
agentrelationships
left outer join agents
on
agentrelationships.agentidparent = agents.agentid
join agents as a2 on
agentrelationships.agentidchild = a2.agentid
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.
Thank you.
Regards,
Rich Duzenbury
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
