Some kind of lookup query

[borge]

Hi,

I am an Access novice and need help please.

I have two tables.

One has all UK postcodes and related categories.

The second has 5,000 postcodes.

For all of the postcodes in table 2, I want to look up the category in table one, appending these as an additional column.

I have no idea how to do this and I am looking for someone to give me simple instructions.

Can anyone help?

Thanks,
George

[alansidman]

Try this:

Select table2.postcode, table1.postcode, table1.category
From table2 LEFT Join table1 on table2.postcode = table1.postcode;

Change your table and field names where appropriate