How do i Add Column with data to existing table.

Question

Hello.

I have a problem.

I have 1 table with lets say 30 columns and 220,000 rows.

And i have another table with 1 column

In the first table i have a field with item number and in the second table i have only selected item numbers that fulfill special criteria.

What i want to do is to this first big table add column in the end and insert there 0 or 1 . 1 if item number exists in second table and 0 if it doesnt. I have been trying to do lots of weird things but none work as i would like it to :(

Any ideas for newbie ?

Answer 1

Here is a very simple example:

The tables:

and

The query in design view:

The query in datasheet view:

You can use the query as record source for forms and reports.

Answer 2

Do you really need to add a column to the first table? You can return the 0/1 (or False/True) in a query based on both tables, with a left join on item number.

Answer 3

I need all the data that is contained in the first table (nothing is allowed to be missing) for further report generation.

If i make query joining them by item number , what will be the result ?

Answer 4

Amazing, this is what i needed !!!

Thank you so much :)

It's so hard to understand how what works.

Answer 5

https://www.w3schools.com/sql/sql\_join\_left.asp

this may be helpful to understand.