Dan: hope it works for you! Having the same table listed more than once in a view isn't exactly intuitive. But once I learned how to do it, I have several views that get all the data for the latest date, or earliest date, etc...
Karen In a message dated 3/21/2012 1:40:43 PM Central Daylight Time, [email protected] writes: > Thanks. I would never of thought of that! > > Dan > > From: [email protected] > Sent: Wednesday, March 21, 2012 9:49 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: SQL Help > > > > Just doing this off the top of my head, but this should work: > > select zipcode, dlrnum, zipdistance from tablename t1, tablename t2 where > t1.zipcode = t2.zipcode and t2.zipdistance = (select min(zipdistance) from > tablename where zipcode = t1.zipcode) > > You use the same table (view) name everywhere in the statement. > > Karen > > > In a message dated 3/21/2012 11:33:57 AM Central Daylight Time, > [email protected] writes: > >> I have a view that has each zipcode, dlrnum, zipdistance >> >> I need to find and store the zipcode, dlrnum based on the minimum >> distance. >> >> I can find the minimum distance by zipcode but how do I get the dlrnum as >> well? >> >> I know there must be a way to use a sql to get this but am coming up >> blank. >> >> > > > > >
