Hello
I created a database on Access with two tables, Table1 and Table2 . My question is, it is possible to join the columns from Table2 in Table1 ? If it is possible. What do i have to do?
Thanks

>it is possible to join the columns from Table2 in Table1 ?

Joins

Thanks i will try that
but if i want to save the columns who are join at table1 into is original table (table2). By the way sorry about the lack of information on this threat but i create the database in acces, but i am using vb 2008 to make a software and there is where i have a problem

>but if i want to save the columns who are join

You must have to include/add all not null columns from both tables.

>i create the database in acces, but i am using vb 2008

You can save this joins into access db. Saved join called view.

>but if i want to save the columns who are join

You must have to include/add all not null columns from both tables.

>i create the database in acces, but i am using vb 2008

You can save this joins into access db. Saved join called view.

That that help me alot

This question has already been answered. Start a new discussion instead.