Re: INNER JOIN

From: Jörn Fieg <_at_wmd.de>
Date: Thu, 23 Dec 1999 17:38:35 +0100
Message-ID: <3862500A.A18D593A@wmd.de>

Hi!

You have to add the table you wat to join to your from-clause and define the join condition at the where-clause. So it look like this:

SELECT Difetti.*, DescrDifetti.*
FROM Difetti, DescrDifetti
WHERE DescrDifetti.CodDifetto = Difetti.Coddifetto

Renato wrote:

> Dear,
>
> This Quesry SQL work fine to ACCESS but not with ORACLE 7
>
> SELECT Difetti.*, DescrDifetti.*
> FROM DescrDifetti
> INNER JOIN Difetti ON DescrDifetti.CodDifetto = Difetti.Coddifetto
>
> Have some information for me ?
> Regards
> Renato

--

---

Jörn Fieg                                               WMD GmbH
to replay, delete >remove_this< from the adress         Hamburg /

Germany Received on Thu Dec 23 1999 - 10:38:35 CST