From: Michael Widenius
Date: April 3 1999 9:46am
Subject: MySQL and Access Query
List-Archive: http://lists.mysql.com/mysql/1370
Message-Id: <14085.58112.179348.551968@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Paco" == Paco Maldonado <spine@stripped> writes:

Paco> I got a problem, i have a database in access and i have made a query and
Paco> copied it to the clipboard:

Paco> SELECT Entity.Name, Entitats.Street, Entitats.Phone, 

Paco> Activities.Activity, Epigrafs.Epigraf

Paco> FROM Epigrafs INNER JOIN 

Paco> (Entity INNER JOIN 

Paco> (Activitaties INNER JOIN EntityActivitaties 

Paco> ON Activities.IDactivity = EntityActivities.IDactivity) 

Paco> ON Entity.IDentity = EntityActivities.IDentity) 

Paco> ON Epigrafs.IDepigraf = EntityActivities.IDepigraf

Paco> ORDER BY Entity.Name;

Paco> I have then, the same DB in my linux box with mysql, so this query is
Paco> incorrect....
Paco> whats can i do?

Hi!

MySQL doesn't understand the 'INNER' noice-word.
(I have fixed this for MySQL 3.23)

The above is equal to:

SELECT Entity.Name, Entitats.Street, Entitats.Phone, 
Activities.Activity, Epigrafs.Epigraf
FROM Epigrafs,Entity, Activitaties, EntityActivitaties 
WHERE Activities.IDactivity = EntityActivities.IDactivity AND
Entity.IDentity = EntityActivities.IDentity AND Epigrafs.IDepigraf =
EntityActivities.IDepigraf
ORDER BY Entity.Name;

Regards,
Monty