Merging two Tables

[Karl Cox]

I am trying to figure out the SQL to take care of this table merge: I have two tables of identical structure (TABLE A & TABLE B) that I would like to merge into a new table (TABLE C). I want identical rows from each table to not show up as two separate rows in the final table (I do not want duplicates).

EX:

TABLE A
WORKER ID----SKILL ID----SKILL RATING
1000------------2001------------3
1001------------2459------------1

TABLE B
WORKER ID----SKILL ID----SKILL RATING
1000------------2001------------3
1003------------2923------------2

TABLE C
WORKER ID----SKILL ID----SKILL RATING
1000------------2001------------3
1003------------2923------------2
1001------------2459------------1

NOTE: the row containing a WORKER ID of 1000 was not duplicated in TABLE C

I'm running MySQL 3.23.49

Thanks,

-Karl