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
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
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