Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: rewrite a RIGHT JOIN

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@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?

Received on Fri Oct 11 2002 - 04:46:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US