in my database on **PostgreSQL/PostGIS** I've two tables: a "location" table which main geo field is a MultiPolygon and a "busstop" table which main geo field is a Point.

Given a base point, I would like both to filter all the location within a certain distance from that point (I already know how to do that) and find the closest bus stop with its distance to that point.

Basically I would like to have back a recordset like this:

    --------------------------------------
    | location_1 | bus_stop_234 | 1.1 Km |
    --------------------------------------
    | location_2 | bus_stop_106 | 1.2 Km |
    --------------------------------------
    | location_3 | bus_stop_827 | 1.6 Km |
    --------------------------------------
    | location_4 | bus_stop_365 | 1.8 Km |
    --------------------------------------

Even better if I can order the results by distance field, like in the example.

I need to do this using a **GeoDjango** query, but even a simple SQL query could be good to let me understand how to perform this kind of query.

Please note that there aren't any **FK** relations between the two tables.

If you need more information, please let me know, in the mean time I keep looking for examples, but I couldn't find of similar.

Thanks