On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote:
> 
> Some people say translate INNER JOINS from Access to WHERE clauses, some say

Personally, I'd say drop Access and all references to it, and begin
redesign using a sensible alternative which doesn't encourage the
production of such abominations, but that's just what you're
attempting, right?  :-)

> mySQL version (with my "custom" aliases to help clarify relationships)
> ====================================================
> 
> SELECT
> Routes.RouteID, Flights.FlightNo, Aircraft.AircraftType, DEPARTCITY.CityName
> AS 'Departure city', DEPARTAIRPORT.AirportName AS 'Departure airport',
> ARRIVALCITY.CityName AS 'Arrival city', ARRIVALAIRPORT.AirportName AS
> 'Arrival airport'
> FROM
> Aircraft, Routes, Flights, Cities AS DEPARTCITY, Cities AS ARRIVALCITY,
> Airports AS DEPARTAIRPORT, Airports AS ARRIVALAIRPORT, AirportLinks AS
> LINK1, AirportLinks AS LINK2
> WHERE
> Routes.FlightNumber = Flights.FlightID AND
> DEPARTAIRPORT.AirportID = LINK1.AirportID AND
> DEPARTCITY.CityID = LINK1.CityID AND
> Routes.Origin = DEPARTAIRPORT.AirportID AND
> Routes.Destination = ARRIVALAIRPORT.AirportID AND
> ARRIVALAIRPORT.AirportID = LINK2.AirportID AND
> LINK2.CityID = ARRIVALCITY.CityID AND
> Aircraft.AircraftID = Flights.AircraftType;

What is that ";" doing there?

> GROUP BY
> Routes.RouteID, Flights.FlightNo, Aircraft.AircraftType,
> ARRIVALAIRPORT.AirportName, ARRIVALCITY.CityName, DEPARTAIRPORT.AirportName,
> DEPARTCITY.CityName;

-- 
     Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software & Serv. Contract programmer, server bum.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to