Re: [GENERAL] Join query query

2013-02-14 Thread Amit Kapila
On Thursday, February 14, 2013 4:31 AM Andrew Taylor wrote: > Hi, > I'd like to do something which I think should be quite easy - that is join 2 tables and create a new table. > Table A postcode_input has columns which include postcode, eastings, northings. there are 1,687,605 rows. > Table B bng

Re: [GENERAL] Join query query

2013-02-13 Thread Sergey Konoplev
On Wed, Feb 13, 2013 at 3:01 PM, Andrew Taylor wrote: > And ended up with a table 13,708,233 rows long with what looks like plenty > of duplicated rows. Some but not all are duplicated. What can I do to sort > this out? It means that (e, n) pairs are not unique in A and B and you got a superposit

[GENERAL] Join query query

2013-02-13 Thread Andrew Taylor
Hi, I'd like to do something which I think should be quite easy - that is join 2 tables and create a new table. Table A postcode_input has columns which include postcode, eastings, northings. there are 1,687,605 rows. Table B bng_lat_long has columns lat, lon, e, n. There are 1,687,605 rows. eas