merge 2 tables

**mi227** · 06-27-2008, 01:18 PM

Is it possible to merge 2 tables (eg table 2 into table 1), so all rows from both tables are present in one table?

The problem I have is if the rows are not in the same order
it does not work right.

I just want the price to update next to the right names

Eg
NAME-----Type-------Price
ab --------1-----------10
ac --------2-----------20
as --------3-----------30
af --------4------------40

Table 2

NAME-----Type------Price
as---------3----------35
af---------4----------45
ab---------1----------15
ac---------2----------25

ag---------5----------55 <------ New Row