wireless=# select a.ssid, b.* from ap_current a join gps_info b on (a.bssid = b.bssid) where b.bssid = '02:a0:f8:6e:8f:ad';
     ssid     |       bssid       |      source       |            time            |    alt     |   spd    |  heading   | fix | signal | noise |                    pos
--------------+-------------------+-------------------+----------------------------+------------+----------+------------+-----+--------+-------+--------------------------------------------
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:32:57.162503 | 851.070007 | 4.257887 | 203.814667 |   2 |    -85 |   -95 | 0101000000DD60A8C30A3544405776C1E09A0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:32:58.184148 | 840.840027 | 0.000000 | 203.814667 |   3 |    -88 |   -95 | 0101000000E3512AE109354440AAB69BE09B0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:00.232532 | 849.750000 | 0.000000 | 203.814667 |   3 |    -87 |   -95 | 010100000060730E9E0935444045D7851F9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:02.282552 | 845.130005 | 0.000000 | 203.814667 |   3 |    -88 |   -95 | 0101000000E3512AE10935444045D7851F9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:04.326432 | 846.119995 | 0.000000 | 203.814667 |   3 |    -87 |   -95 | 0101000000AE10566309354440E0F76F5E9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:06.375834 | 847.440002 | 0.000000 | 203.814667 |   3 |    -86 |   -95 | 01010000001F84807C09354440E0F76F5E9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:08.425423 | 847.770020 | 0.000000 | 203.814667 |   3 |    -85 |   -95 | 0101000000EA42ACFE08354440E0F76F5E9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:10.473286 | 850.409973 | 0.000000 | 227.720245 |   3 |    -86 |  -105 | 0101000000B401D8800835444021E7FD7F9C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:12.521551 | 851.400024 | 0.000000 | 227.720245 |   3 |    -85 |   -95 | 01010000003123BC3D0835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:13.749776 | 851.400024 | 0.000000 | 227.720245 |   3 |    -80 |   -95 | 0101000000F0332E1C0835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:15.184107 | 851.729980 | 0.000000 | 227.720245 |   3 |    -75 |   -95 | 0101000000F0332E1C0835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:15.693339 | 851.729980 | 0.000000 | 227.720245 |   3 |    -79 |   -94 | 01010000003123BC3D0835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:17.742296 | 851.729980 | 0.000000 | 227.720245 |   3 |    -75 |   -94 | 010100000073124A5F0835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:22.144347 | 852.390015 | 0.000000 | 227.720245 |   3 |    -83 |   -95 | 0101000000B401D8800835444062D68BA19C0054C0
 CARDKRAFTWRX | 02:a0:f8:6e:8f:ad | 00:a0:f8:6a:0c:a5 | 2005-12-01 13:33:24.3995   | 853.049988 | 0.000000 | 227.720245 |   3 |    -90 |   -95 | 0101000000B401D8800835444062D68BA19C0054C0
(15 rows)