daniel.winson
Registered User.
- Local time
- Today, 14:09
- Joined
- May 28, 2009
- Messages
- 18
Hi,
I am trying to design a query that will ask the user for a 'postcode' and return a list of organisations that operate in that postcode.
My database has two junction tables organisationPostcode and organisationLocation as some of the organisations listed operate in specific postcodes, others operate accross entire regions.
I can query either one easily but when I try to combine it it stops working... if someone can point me in the right direction or provide an example of a similar query in use I'd really appreciate it
I am trying to design a query that will ask the user for a 'postcode' and return a list of organisations that operate in that postcode.
My database has two junction tables organisationPostcode and organisationLocation as some of the organisations listed operate in specific postcodes, others operate accross entire regions.
I can query either one easily but when I try to combine it it stops working... if someone can point me in the right direction or provide an example of a similar query in use I'd really appreciate it