Multiple Select Statements?

Results 1 to 2 of 2

Thread: Multiple Select Statements?

  1. #1
    Rob Guest

    Default Multiple Select Statements?

    I am selecting data from a table based on certain criteria. Part of the data returned from the table is the site Latitude/Longitude. What I would like to do is be able to sort this result set based on calculations of how far the site is from some latitude/longitude entered by the user in the original search. (I already have the distance calculations part correct.) What I&#039m doing right now is selecting all the data from the table, and as I&#039m looping through writing it all out, I perform the distance calculations and write out the distance with all the table data retrieved.<BR><BR>Is there a way to somehow calculate the distance and add it to the result set, then sort this second result set? Is there such a thing as selecting and ordering based on a previous select statement?<BR><BR>Thanks for any suggestions,<BR>Rob<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Multiple Select Statements?

    Show us some code.. I think that may help on this one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts