Fw: Merging two database tables --- Please I need Help

------=_NextPart_000_0048_01C4FCB6.360E49D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have 2 table in one database and I want to merge the two into one =
table.

The tables are as follows ...=20
tableOne

have 12 columns and Field1 and Field9 are primary keys

tableTwo
have 12 columns and rec_id as autoincrement, primary key and sufix as =
also primary key.

The nature of this data is as follows:
They are one or more records in each table that have the same member id =
but the differ on the sufix of each individual member eg.
mem_id =3D 100001 sufix =3D 1 name =3D my name
mem_id =3D 100001 sufix =3D 2 name =3D my name2
mem_id =3D 100001 sufix =3D 3 name =3D my name3

so a member is identified by the mem_id and the suffix

tableTwo contains all the data in tableOne and we want to get all new =
records in tableTwo into tableOne buy just running a query
how do I do that get all the records that are not in tableOne from =
tableTwo

Please I need help on this one

------=_NextPart_000_0048_01C4FCB6.360E49D0--