Excel 2007 : How to combine two table

hello everyone
i got two table
the first one get 3 column - A B C (x coordination, y coordination, street)
the second one get 2 column - C D (street, ID_NUM)
column C contain the same information

I need to combine them to third table - A B C D

* not all the streets name (column C) that are in the first table is also in the second table

thank you all