I need the IP addresses of the northeast states of US - what is best way to get the?
Obviously as accurate as possible but know they are not much over 85%
Moderator: Moderators
select ip from ip4 where city in
(select city from cityByCountry where state in
('Connecticut','Maine','Massachusetts','New Jersey',
'New Hampshire','New York','Pennsylvania',
'Rhode Island','Vermont'));
select ip from ip4, cityByCountry where
ip4.city = cityByCountry.city and
cityByCountry.state in
('Connecticut','Maine','Massachusetts','New Jersey',
'New Hampshire','New York','Pennsylvania',
'Rhode Island','Vermont');
Users browsing this forum: No registered users and 4 guests