eplied!
Here's the final query. It runs in about .3 second:
SELECT Dealers.*,
ROUND(SQRT(POW(2285-Zips.North,2)+POW(4760-Zips.West,2)),1) AS Distance
FROM Dealers
INNER JOIN Zips ON Dealers.Zip = Zips.Zip
ORDER BY Distance
> -Original Message-
> From: Asendorf, John [mailto
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
> -----Original Message-
> From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 27, 2002 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: Trouble converting SQL from Access
>
>
> I'm att
I'm attempting to convert an application from ASP/Access to PHP/MySQL My
problem is in the SQL conversion.
The SQL determines distance between two zip codes:
This is the Access original:
SELECT Dealers.*, ((2285-Zips.North)^2+(4760-Zips.West)^2)^.5 AS Distance
FROM Dealers INNER JOIN Zips ON De
