You dont need to then Just alias that tables as 2 different tables and query itself
select bla from postcodes Postcodes, postcodes Suburbs where ...... get what I mean? Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Phil Rasmussen Sent: Thursday, February 06, 2003 6:13 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Postcode question No no, I already have them all in the 1 table Steve. So I have all the suburbs and their respective postcode/state/lat-long.....what I am trying to do is now associate each suburb with its tourist region. So that in my search system, I can then allow people to search an entire region, instead of having to select individual suburbs or postcodes. Ie I have a table called regions that just has Postcode | Region as the fields and uses Postcode as the primary key. That way I can do a link between the 2 tables on postcode and find out what regions they are in. Does this make sense? Phil "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:22689@cfaussie... > > If you have the suburbs, then all you need are the postcodes > > If the user searches by Postcode then get the long/lat and then search the > suburbs with that criteria, and visa-versa > > should be able to look up between the 2 tables in either direction > > Regards > > Steve Onnis > Domain Concept Designs > +61 422 337 685 > +61 3 9444 7504 > > http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> > > ("If you think it can't be done, you haven't asked me!") - Steve Onnis > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Phil > Rasmussen > Sent: Thursday, February 06, 2003 5:38 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Postcode question > > > Thanks for the solutions guys. I should have probably mentioned that I > already have all the Australia Post postcodes in a table, and have lat/long > co-ords for every suburb. I just figured that instead of manually entering > regions into another table I could find some rules. Thats cool. Lucky we > only cover QLD and Northern NSW at this point so I don't have too much to > enter manually. > > Oh and Ayudh I should have mentioned that the regions I want to specify are > the tourism ones. So things like Gold Coast, Sunshine Coast....just the > general regions that a tourist would relate to. I think I have no choice but > to map these manually. > > Thanks all, > > Phil > > > "Rob McLennan" <[EMAIL PROTECTED]> wrote in message news:22687@cfaussie... > > > > Phil, > > > > Steve suggested using the distribution center as the grouping method. > > We've used this on a recent site and it seems to be satisfactory for our > > clients purposes. Nothing is going to be 100% accurate. > > As Ayudh said without spending heaps of time manually mapping the > postcodes > > to regions this is probably the best cost/time solution. > > > > Rob > > > > -----Original Message----- > > From: Phil Rasmussen <[EMAIL PROTECTED]> > > Newsgroups: cfaussie > > To: CFAussie Mailing List <[EMAIL PROTECTED]> > > Date: Thursday, February 06, 2003 2:02 PM > > Subject: [cfaussie] Postcode question > > > > > > >I am just fancying up our database, and have decided to implement a > region > > >feature for suburbs. Initially I was just going to create another table > for > > >regions, add all the regions in, and then associate a region to a suburb. > > Ie > > >Regions would be..Gold Coast, Brisbane, Sunshine Coast, Cairns, Sydney... > > > > > >This however involves human intervention in going though every suburb and > > >selecting the region its in, plus its a little clumsy. I figured that > since > > >the postcodes are already stored for every suburb, that I should create > > >another table which contains all postcodes and the region they belong to. > > >That way all suburbs will automatically be able to find what region they > > are > > >in through a simple JOIN in the query. > > > > > >Then I got to thinking 1 step further, and maybe I should store a rule > for > > >each region. Ie, all postcodes that start with 40-- would be Brisbane, > and > > >so on for all regions. > > > > > >Anyone have something similar setup whereby they deduce regions from > > >postcodes? > > > > > >Thanks, > > > > > >Phil > > > > > > > > >--- > > >Outgoing mail is certified Virus Free. > > >Checked by AVG anti-virus system (http://www.grisoft.com). > > >Version: 6.0.449 / Virus Database: 251 - Release Date: 29/01/2003 > > > > > > > > > > > >--- > > >You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > >To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > > > > >MX Downunder AsiaPac DevCon - http://mxdu.com/ > > > > > > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.449 / Virus Database: 251 - Release Date: 29/01/2003 > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 29/01/2003 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
