Re: rewrite a RIGHT JOIN
From: Jan.Hidders <hidders_at_hcoss.uia.ac.be>
Date: 11 Oct 2002 11:46:58 +0200
Message-ID: <3da69e12$1_at_news.uia.ac.be>
Date: 11 Oct 2002 11:46:58 +0200
Message-ID: <3da69e12$1_at_news.uia.ac.be>
In article <abb373f7.0210110035.7a77981b_at_posting.google.com>,
Dan <paraschiv_at_rol.ro> wrote:
>Hello Everybody,
>
>
> Here is my problem: I have an SQL query that works fine on DB2,
>but I need a query that produces the same results to work on MySql also.
>My DB2 query uses a RIGHT JOIN that is unsupported by MySql.
MySQL supports LEFT JOIN and RIGHT JOIN. Which version are you using?
- Jan Hidders