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