How could I write this inner select

Here's the portion of my table that I want to select from:

select id, actor_id, actor_display_name, posted_time, display_name, geo_coords_lat, geo_coords_lon, location_name, posted_day from verizon where posted_day BETWEEN '2014-03-01' and '2014-03-05'

Open in new window


I want that to be my nested query. How do I grab from that inner select a range of geo_coords_lon and geo_coords_lat?

In other words, I want to select from my inner select those rows that are within a given latitude and longitude range.

How?

BTW: I have tried to create a temporary table and while that approach does work, I'm trying to avoid a situation where I'm "writing" anything in that it takes more time than a select statement. I just need that select statement to be limited to the subquery that I've written.

What do you think?
brucegustPHP DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurCommented:
I think the temporary table with ENGINE=MEMORY is almost certainly what you want.

INNER is a term of art in database work; I'm not seeing any applicability here.

How many rows do you expect to get from the query as written?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
brucegustPHP DeveloperAuthor Commented:
Ray, I went with an earlier suggestion you made as far as inserting directly from a select statement. Worked like a peach!

Thanks!
0
Ray PaseurCommented:
Thanks for the points.  I hope you'll take a moment to abstract out a subset of that big table, perhaps every 1000th row, and post a link to it.  If we have some test data to work with, we can give you better solutions that are more on point when we are answering these questions!

All the best, Ray
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.