I have a boundary table containing 71 boundaries. I also have a table containing 71000 points, which have a postcode attached. Is the any way of writing a SQL query that will give me all post code within a boundary, but will only return each post code once, and return the post code that has the most instances if in two different boundaries.
E.G. NE33 2RL has 4 properties in 1 boundary and 8 in another. I only want the postcode to appear within the boundary that it has 8 matches in. Thanks in advance Andrew Tracey Information Support Officer Corporate Information Corporate Development South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] ************************************************************************************************ ************************************************************************************************ Please do not print this e-mail if you can help it - and help protect the environment. ************************************************************************************************ This Message may contain confidential information and is protected by copyright. If you receive it in error please notify us and delete it without making use of or copying it. The addressee and other employees within the Council may read and copy any e-mail reply to this message and other e-mails you send to us. Whilst we use virus checking procedures we accept no liability for viruses and recipients must rely on their own virus checking procedures. ************************************************************************************************ The Council's web site address is www.southtyneside.info --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16045