W dniu 01.04.2016 o 14:36, Marcin pisze:
nie pobiera netdevices :/
SELECT nd.id http://nd.id, nd.location_city, nd.location_street, nd.location_house, nd.location_flat, nd.location, (SELECT ls.name http://ls.name FROM location_cities lc JOIN location_boroughs lb ON lb.id http://lb.id = lc.boroughid JOIN location_districts ld ON ld.id http://ld.id = lb.districtid JOIN location_states ls ON ls.id http://ls.id = ld.stateid WHERE lc.id http://lc.id = nd.location_city) AS area_woj, (SELECT ld.name http://ld.name FROM location_cities lc JOIN location_boroughs lb ON lb.id http://lb.id = lc.boroughid JOIN location_districts ld ON ld.id http://ld.id = lb.districtid JOIN location_states ls ON ls.id http://ls.id = ld.stateid WHERE lc.id http://lc.id = nd.location_city) AS area_pow, (SELECT lb.name http://lb.name FROM location_boroughs lb JOIN location_cities lc ON lc.boroughid = lb.id http://lb.id WHERE lc.id http://lc.id = nd.location_city) AS area_gmi, (SELECT Concat('ls.ident', '_', 'ld.ident', '_', 'lb.ident', '_', 'lb.type') FROM location_cities lc JOIN location_boroughs lb ON lb.id http://lb.id = lc.boroughid JOIN location_districts ld ON ld.id http://ld.id = lb.districtid JOIN location_states ls ON ls.id http://ls.id = ld.stateid WHERE lc.id http://lc.id = nd.location_city) AS area_terc, (SELECT lc.name http://lc.name FROM location_cities lc WHERE lc.id http://lc.id = nd.location_city) AS area_city, (SELECT lc.ident FROM location_cities lc WHERE lc.id http://lc.id = nd.location_city) AS area_simc, (SELECT tu.cecha FROM teryt_ulic tu WHERE tu.id http://tu.id = nd.location_street) AS address_cecha, (SELECT (CASE WHEN ls.name2 IS NOT NULL THEN Concat('ls.name2' , ' ', 'ls.name http://ls.name') ELSE ls.name http://ls.name END) AS name FROM location_streets ls WHERE ls.id http://ls.id = nd.location_street) AS address_ulica, (SELECT tu.sym_ul FROM teryt_ulic tu WHERE tu.id http://tu.id = nd.location_street) AS address_symul, (CASE WHEN (nd.location_flat IS NULL OR nd.location_flat = '') THEN nd.location_house ELSE Concat('nd.location_house ', '/', 'nd.location_flat') END) AS address_budynek, (SELECT zip FROM pna WHERE pna.cityid = nd.location_city AND (pna.streetid IS NULL OR (pna.streetid IS NOT NULL AND pna.streetid = nd.location_street)) LIMIT 1) AS location_zip, ports, nd.longitude, nd.latitude, nd.status, nd.netnodeid, (CASE WHEN nd.invprojectid = 1 THEN nn.invprojectid ELSE nd.invprojectid END) AS invprojectid FROM netdevices nd LEFT JOIN netnodes nn ON nn.id http://nn.id = nd.netnodeid WHERE EXISTS (SELECT id FROM netlinks nl WHERE nl.src = nd.id http://nd.id OR nl.dst = nd.id http://nd.id) ORDER BY nd.name http://nd.name, id
BŁĄD: relacja "teryt_ulic" nie istnieje LINE 21: (SELECT tu.cecha FROM teryt_ulic tu WHERE tu... ^ ********** Błąd **********
BŁĄD: relacja "teryt_ulic" nie istnieje Stan SQL: 42P01 Znak: 1628
brak view?