ERROR: column gh.lan_frequency does not exist LINE 4: gh.lan_frequency ^ SELECT hl.latitude as a_lat, hl.longitude as a_long, gl.latitude as b_lat, gl.longitude as b_long, gh.lan_frequency FROM dbiua_hosts_v h JOIN dbiua_locations hl ON h.lid=hl.lid JOIN dbiua_hosts_v gh ON h.wan_nid=gh.lan_nid JOIN dbiua_locations gl ON gh.lid=gl.lid WHERE gl.lid!=hl.lid GROUP BY 1,2,3,4,5 at /etc/perl/dbiua/object/dbiuaapi/display.pm line 584.