[EMAIL PROTECTED] wrote:
> SELECT DISTINCT tbl_restaurant.restaurant,
> tbl_restaurant_location.postal_code, tbl_restaurant_location.latitude
> AS latitude, tbl_restaurant_location.longitude AS longitude, distance
> (49.24894, -122.90419, latitude, longitude) AS distance FROM
> tbl_restaurant, tb
Hi,
Removing the double single-quotes from the distance function fixed the
problem, thanks. I've now encountered another problem...
I have the following (ugly) query:
SELECT DISTINCT tbl_restaurant.restaurant,
tbl_restaurant_location.postal_code, tbl_restaurant_location.latitude
AS latitude, t